Q: Nested if

JIM.H. · Dec 31, 2004

Hello,
Is it possible to create a nested if statment in excel?
Thanks,
Jim.

JIM.H. · Dec 31, 2004

I found the answer of this, it is like if(a1=b1,1,if(a2=b2,2,0))

Debra Dalgleish · Dec 31, 2004

You can create a nested IF formula. For example:

=IF(A2>5,0,IF(B2>10,0,C2))

or

=IF(A2>5,IF(B2>10,0,C2),0)