Forum Discussion

xmishaniagx's avatar
xmishaniagx
Copper Contributor
Jan 31, 2018
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...
excel
Formulas and Functions
  • Damien_Rosario's avatar
    Damien_Rosario
    Jan 31, 2018
    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
xmishaniagx's avatar
xmishaniagx
Copper Contributor
Feb 01, 2018

Thank you, that worked.  However, I do not really understand the logic. ;-) I guess I would need to look into how you did it.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 01, 2018

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

Resources