| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
=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 |
Threaded Mode
