Forum Discussion
Solved
Excel formula for 3 condition
Hai, I have some problem with formula in excel when i has 3 condition that need follow, Condition 1 : High <= 5, True, False Condition 2 : Medium<=20, True,False Condition 3 : Low<=30,True,Fal...
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 " "..
already solve the issue with your advice... I just add letter M with " "..