Connecting multiple IF THEN formulas in one cell
"Mike H" wrote:
Maybe
=IF(AND(B6="M",C6="L"),"Moved Down from Medium",IF(AND(B6="M",C6="M"),"No
Movement",""))
If's can be nested up 7 deep.
Mike
"hmlguru" wrote:
Is it possible to connect more than one formula to a cell? I am fairly new at
this. I have the following formula that works perfectly:
=IF(AND(B6="M",C6="L"),"Moved Down from Medium")
I need to know how to add another formula to the same cell if B6="M",C6="M"
and my result would be "No Movement"
How many separate formulas can apply to one cell?
|