formula needs modification
 

=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

formula needs modification
 

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",""))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

formula needs modification
 

That part is working fine, it's the part in the middle
--
Libby


"Don Guillett" wrote:

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",""))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

formula needs modification
 

Send me a workbook if you like with detailed instructions and examples of
failure.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Libby" wrote in message
...
That part is working fine, it's the part in the middle
--
Libby


"Don Guillett" wrote:

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",""))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

formula needs modification
 

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

On Jul 20, 9:34 am, Libby wrote:
=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