IF

Hi Usman,

I hope you enjoyed your Excel training. Thank you for your question.

The IF function allows Excel to display different answers dependant on certain criteria being met or not met (for example to show whether a student has passed or failed an exam).

To create the formula, you click in the cell where you want the answer to appear and use the Insert Function button (fx) to choose the If function.

In the If function dialogue box you have 3 separate areas