Excel Intermediate

Hello Tracy

Thank you for your question and welcome to the forum.

The IF function is used in situations where you would like Excel to choose between two alternative entries to put into a cell, based on Excel evaluating the content of another cell.

There are three parts to the function:
1. Logical test, where you are asking Excel to evaluate a cell in your spreadsheet (e.g. see if it is equal to =, less than <, greater than >, or not equal to <> a certain value).
2. Value if true: what you'd like Excel to do if your logical test is met/is true.
3. Value if false: what you'd like Excel to do if your logical test is not met/is false.

The second and third parts (value if true and value if false) could get Excel to perform a calculation, put a text or number value in the cell, or leave the cell blank (denoted by "").

I hope this helps.

Kind regards
Amanda