Formula

G

Guest

=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
 
G

Guest

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
 
G

Guest

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)
 
S

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with formula 5
formula needs modification 4
How many IF functions can you have? 4
If then formula 11
Problem tabbing between merged cells in Excel 2010 0
Fixed column, variable rows 4
auto sort macro 1
using a function pointer in another function 5

Top