If statement issues

[ashleym8]

I have an if statment with mulitple criteria. One of the if statements in my formula I need to have this if statement in it..

if(h2=(“2a”,"1A","1B","1D", "1G","1H","1I","1J"),0,1

here is the whole if statement that i need to add the above too.

=IF(A2="",0,IF(E2="CL",0,IF(P2<650,0,IF(IFERROR(VALUE(G2),0)>0,0,IF(Q2="n",0,IF(R2="n",0,IF(I2=52,0,IF(S2<>"",0,IF(J2<>"No relationships",0,1))))))))+IF(T2>0,1,0))

Any suggestions?

 

[GK039]

Hi,

If you use 2003 this won't work as you are limited to seven nested IF's


George

I have an if statment with mulitple criteria. One of the if statements in my formula I need to have this if statement in it..

if(h2=(“2a”,"1A","1B","1D", "1G","1H","1I","1J"),0,1

here is the whole if statement that i need to add the above too.

=IF(A2="",0,IF(E2="CL",0,IF(P2<650,0,IF(IFERROR(VALUE(G2),0)>0,0,IF(Q2="n",0,IF(R2="n",0,IF(I2=52,0,IF(S2<>"",0,IF(J2<>"No relationships",0,1))))))))+IF(T2>0,1,0))

Any suggestions?

 

[scottylad2]

All the conditions that your looking for that will evaluate to 0 you should wrap in an
=if(Or(,,,,,,,,,,,),0,IF(then the other conditions here,"")