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

what I need is t-u or u-t is <=50 and = -100 should be
immaterial and t-u or u-t is 50 or < -100 is left blank
--

--
Libby

try:

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


HTH

"Libby" wrote:


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

what I need is t-u or u-t is <=50 and = -100 should be
immaterial and t-u or u-t is 50 or < -100 is left blank
--

--
Libby

I propose the following formula:

=IF(W32=1, IF(OR(AND(T32-U32<=50, T32-U32=-100),
AND(U32-T32<=50,U32-T32=-100)), "Immaterial", ""), V32)

Thx that's it.
--
Libby


"Stephane Quenson" wrote:

I propose the following formula:

=IF(W32=1, IF(OR(AND(T32-U32<=50, T32-U32=-100),
AND(U32-T32<=50,U32-T32=-100)), "Immaterial", ""), V32)

The mid point of -100 and 50 is -25 and the range is +- 75 so I think that
this may do it:

=IF(W32<1,V32, IF(T32=U32,"pb",IF(ABS(ABS(T32-U32)-25)<=75, "Immaterial",
"")))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Libby" wrote in message
...

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

what I need is t-u or u-t is <=50 and = -100 should be
immaterial and t-u or u-t is 50 or < -100 is left blank
--

--
Libby