formula needs modification

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
If w32<>=1 then v32 should be returned.

If w32=1 then your formula below takes over
IF(T32-U32=0,"pb",IF(AND(T32-U32>=-100,T32-U32<=50),"immaterial",""))
 
I'm rather confused as to what you're looking for. A couple of
observations:

You're testing for T32-U32 to be between -100 and 50, inclusive, and
if it is you want to see "immaterial". A result of 82 is outside of
the "immaterial" range of numbers, and so *is* material.

In your example, if t (I'm assuming T32) is 2, then u (assuming U32)
*will* return "immaterial" for values between 0 and -48, which produce
results of 2 to 50.

Mark Lincoln
 
Back
Top