Excel If Conditions

There is a simple example: if the exam mark is greater than or equal to 90, then students can get an A, if the mark is lower than 90, students can get a B. I f we use “IF” in excel, it should be:

And the formula is:

This is a simple “if” condition as there is only one “if” used in this case. When we write this “if” formula, first, we need to write “=IF()”, then click one number in “Mark” line, write down the condition that “>=90”, the result that mark is larger than or equal to 90 is in the behind, mark is lower than 90 is at last because this result could be get only when the previous one is “denied’. We can turn this formula into “if the mark is greater than or equal to 90, the result is A, or it would be B”.

Now we turn to multiple if conditions:

When the age <=10, the function should return 'kid';

When the age is 10- 18 , the function should return 'teenager';

When the age is 18- 64 , the function should return 'adult';

When the age >=65 , the function should return 'senior'.

According to the description above, we can get:

The formula is:

We should notice that when it comes to multiple if conditions, we use another if condition to replace “B” in the simple if condition. And in this case, if we write “IF(10<A2<=18,"teenager"", then this is wrong, because”<” and “<=” are in the same priority. And when we write ”IF(A2<=10,"kid",IF(A2<=18,"teenager"”, it means if age smaller or equal to 10, it’s kid, or if 10<age<=18, it’s teenager.

FUNTERN Associate: Jin Wang