Forum Discussion
Solved
nested "IF" with "AND" and "IF" with "OR" function
Hi All, can somebody please help with the following? I am trying to do 3 conditions, using nested "IF" with "AND" functions and "IF" with "OR" functions. Let's assume cell c3=2 and cell c4=3. wha...
- Hi there
Try this:
=IF(AND(C3=2,C4=3),"100",IF(AND(C3<>2,C4<>3),"0","50"))
Hope that works? Let us know how you go.
Cheers
Damien
Alternatively that could be as
=TEXT(((C3=2)+(C4=3))*50,"0")
if the result shall be returned as text
Thank you, that worked. However, I do not really understand the logic. ;-) I guess I would need to look into how you did it.
That is based on the fact what TRUE is equal to 1 and FALSE is equal 0.
If both are TRUE you have 2*50
If one OR another is TRUE you have 1*50
If both are false you have 0*50
