One of the most powerful functions in Excel is the IF() function. The idea of an If() statement is based on the idea of :
- A question
- What do you do if the answer is Yes?
- What do you if the answer is No?
I do understand that life is usually more complex than that but as a building block, this is incredibly powerful. In this video I am going to use one of the files that I use in training. It combines two things I love: an IF() function and 80s music. In fact I include a handy little 80s music video list , that you can view after you have gone through the tutorial. Don’t say I don’t provide some entertainment as well 🙂
Another point I mention in the video is how to fix cells