If condition between values

[bkcffee]

hi
can u help me plz with this if condition i think there's something wrong with it :X

=IF(T10<=100>76," ",IF(T10<=75>50,1,IF(T10<=50>25,2,IF(T10<=25>0,3,IF(T10<=0,"warning")))))

im trying to add number 1, =if cell value =< 75 and >50
2, =if cell value =< 50 and >25
3, =if cell value =< 25 and >0
"blank" if value >75
"WARNING" if value=0

ty in advance

[The_Snook]

Hi bkcffee,

Try:

=IF(T10>75,"",IF(T10>50,1,IF(T10>25,2,IF(T10>0,3,IF(T10=0,"WARNING","INVESTIGATION REQUIRED")))))

Regards,

Snook

[Sam Capricci]

you need to add an AND statement like this... =if(AND(t10<=100,t10>76),"",if(and(...
if I'm interpreting your =IF(T10<=100>76 correctly.

[bkcffee]

thanks guys