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 very much, Damien. 

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Feb 01, 2018
No worries friend. You did all the heavy lifting, all I did was adjust your formula to give you the desired result. Great team work!

All the best.

Cheers
Damien

Resources