combining various IF statements

A B C D E F G H
N/A N/A 28-Aug-09 ? ? 200 03-Jul-09 200



=IF(A2=N/A, Lookup - B2

=IF(B2=N/A, Lookup - G2

D2=IF(G2>=NOW()-8,"Default","PAID")

=IF(D2=PAID then LOOKUP H2

If H2<F2 then E2 reads UNDER

=IF(H2>=F2,"UNDER","")

i hope you can understand what it is im trying to say -

your help would be much appreciated


Thanx

Lorna

Originally Posted by NBVC

Kind of confusing, but a guess may be:

=IF(AND(A2="N/A",B2="N/A",D2="PAID",H2>=F2),"Under","")

So all have to be true to get "Under" else if any are false you get a blank.

No it just brings up #N/A

sorry not too sure what you mean.

N/a in both A and B are from previous Vlookups if thats what your asking??

Originally Posted by NBVC

Does this work?

=IF(AND(ISNA(A2),ISNA(B2),D2="PAID",H2>=F2),"Under","")

the above seems to be giving me the answer that i want but

if A2 is not N/A the string should not work? am i right?

Right hopefully the below looks better.. i was getting too confused... so i have changed it all

if B2 read #N/A look at C2
if C2 reads #N/A look at H2
if H2 is more than 0 look at L2
If L2 reads Late Mark K2 as Priority


..B...........C.........H........K........L............
#N/A.....#N/A......100......?........Late .......

I have completely changed it now

Thanx for help so far!!

Lorna