If T = 2 and u = -80

that is 82 but your criteria is = - 100 which it passes AND <= 50 which is
doesn't since 82 is greater than 50 not less than or equal

However that doesn't matter since your formula fails regardless

for what condition do you want it to return V32 and for what do you want it
to return ""?

=IF(AND(W32=1,T32-U32=0),"pb",IF(AND(T32-U32=-100,T32-U32<=50),"immaterial",""))




--
Regards,

Peo Sjoblom




"Libby" wrote in message
...
=IF(W32=1,IF(T32-U32=0,"pb",IF(AND(T32-U32=-100,T32-U32<=50),"immaterial","")),V32)

The above formula works as is, however if the number in u is between 0 and
-100 then it doesn't return immaterial. For example if t=2 and u= -80
then
2-(-80) = 82 which isn't material but it should be. Should I use an
absolute
value or something--
Libby

--
Libby