Forum Discussion
Excel formula for 3 condition
I don't understand what you're trying to do.
You can't use a formula like A1=M because M is not valid; if A1 can be the letter M you have to use A1="M" (with ").
But if A1 it's equal to "M", can't be at the same time compared with a number.
I don't get what you want from the formula and what are the datas in play.
Enlight us so we can help!
Hello,
assuming the cell A1 has a number, try this:
=IF(A1<=5,"H",if(A1<=35,"M",if(A1<=55,"L","neither")))
In words: If A1 is less than or equal to 5, return the letter "H", else, if A1 is less than or equal to 35, return the letter "M", else if A1 is less than or equal to 55, return the letter "L", else return "neither".
If that does not help, please post a sample workbook, mock up the desired result and explain the logic.
=if(A1<=5;"H";if(A1<=35;"M";if(A1<=55;"L";"neither")))
Did you use the semikolon ? I try this formula and it works :)
Only a normal comma didn't work.
Roland Wollenschläger comma or semicolon is a regional setting. European languages use the semicolon in formulas, most other regions use the comma.
