excel word powerpoint courses london - IF Functions

Hi Brian

Thank you for your question.

As you have pointed out through asking this question, the limitation of the IF function is that it can only evaluate the content of one cell.

If you wish to ask Excel to evaluate more than one cell before deciding which action to take (value_if_true or value_if_false) you can combine the IF function with the AND function to do this.

The AND function returns TRUE if all arguments are true; and FALSE otherwise.

Here is an example of how this might work:

Say you need to Excel to evaluate cell A1, A2 and A3 to see if each cell's value is greater than 100. If each cell's value is greater than 100, then Excel displays yes, if not, Excel displays no.

This is how the formula would look:
=IF(AND(A1>100,A2>100,A3>100,"yes","no")

There is also an OR function which returns TRUE if one of the arguments is true; and FALSE if all arguments are false. That way if you needed Excel to perform an action based on any one of several arguments being true, you could use OR in place of AND in the above formula.

I hope this helps.
Amanda