IF statements

Hello Andrew,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding IF statements.

Unfortunately, the IF function can be used in thousands of different ways depending on what the logical test is.

The Syntax of the IF statement begins with IF( then the 'Logical Test' is entered followed by a comma. After the first comma you would insert a value which is applied to the cell where the formula is written only if the logical test is TRUE.

After this value add a second comma. After the second comma you would insert a value which is applied to the cell where the formula is written only if the logical test is FALSE.

Add a closing bracket and the formula is complete.

Here is an example: -

=IF(A1>10,"Over 10","10 or less") returns "Over 10" if A1 is greater than 10, and "10 or less" if A1 is less than or equal to 10

The Syntax is as follows: -

IF(logical_test, [value_if_true], [value_if_false])

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer