Multiple Condition If statement

[cbjhay2006]

I have 3 If conditions that works fine separately but would like to combine them into the one statement.

=IF(K18>=K13,"Primary",IF(K18>=K12,"Secondary",IF(K18>=K11,"Highschool","Nil")))
=IF(L18>=L13,"Primary",IF(L18>=L12,"Secondary",IF(L18>=L11,"Highschool","Nil")))
=IF(M18>=M13,"Primary",IF(M18>=M12,"Secondary",IF(M18>=M11,"Highschool","Nil")))

[ajryan88]

Hi,

Try this formula:

Please Login or Register  to view this content.

This uses the OR function to give you, say, "Primary" if any of the conditions in your 3 formulas are true. If you need them all to be true, then replace each instance of OR with AND.

Let me know if you need some more assistance

[Ron Coderre]

Those 3 formulas test 3 different pairs of cells.
How would you like the formulas combined? What are the new rules?