Excel

Hello Darren

Thank you for your question and welcome to the forum.

The IF function is used to get Excel to evaluate the content of a cell for a certain criteria. If that criteria is met, Excel will display one result in the cell; if the criteria is not met it will display a different result. Basically you are getting Excel to choose between taking two different actions, by evaluating what is in a particular cell.

The IF function requires 3 parts to work:
1. The logical test: which cell you are getting Excel to evaluate, and what your criteria is (e.g. is the amount in the cell equal to, less than or greater than a certain value?)
2. The value_if_true: what you want Excel to do if the logical test is met
3. The value_if_false: what you want Excel to do if the logical test is not met.

I would advise using the insert function button (fx button to the left of the formula bar) to put the IF function into your spreadsheet.

Kind regards
Amanda