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!
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!
- thanks a lot...
already solve the issue with your advice... I just add letter M with " "..But how can A1 be = "M" AND also a number <35???? That can never be TRUE, so what is the point of that IF condition?
