Nested Ifs

**NBVC** · 06-07-2007, 12:18 PM

Try this amendment to my original formula:

=IF(AND(OR(A1={"Approved","Submitted for Approval","In Development","App for IA"}),A2=0),"",OR(AND(OR(A1={"completed","cancelled","Rejected","On hold"}),A2>0),AND(OR(A1={"Approved","Submitted for Approval","In Development","App for IA"}),A2>0)))

Note: Double-Check the key words to make sure they match your key words.

**Mrsm** · 06-08-2007, 04:16 AM

HI,

Thanks for this......However, it seems to be working back to front!!

If the status is "Complete", "Cancelled" etc and there is no date it is returning a blank rather than False and If there is a Date it is returning a false rather than a True. AND If the status is "Approved","Submitted for approval" etc and there is no date - it is returning a False rather than a blank and if there is a date it is returning a True - (which is correct). I have tried to rework it but I still can't get it to work out

Any ideas??

**Mrsm** · 06-08-2007, 04:35 AM

Apologies NBVC, I had the status order incorrect - it does work

You are very helpful and I really appreciate how quickly you have come back to me.

Could you please help with my second If statement - it won't work now!!

Many thanks.

**NBVC** · 06-08-2007, 07:46 AM

Originally Posted by Mrsm

Apologies NBVC, I had the status order incorrect - it does work

You are very helpful and I really appreciate how quickly you have come back to me.

You're welcome.

Could you please help with my second If statement - it won't work now!!

Many thanks.

Not sure which one you are talking about?

You mean this one?:
=IF(G2=TRUE,$A$38,IF(G2=FALSE,$A$39,""))

This one should work with True, False or blank.

What's not working about it?