Posted to microsoft.public.excel.misc

Libby

external usenet poster

Posts: 151

problem with formula

=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

--
Libby

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula problem	Nancy E	Excel Discussion (Misc queries)	4	May 11th 07 06:47 PM
Formula Problem	roxiemayfield	Excel Worksheet Functions	2	May 9th 07 04:25 PM
formula problem	[email protected] uk	Excel Worksheet Functions	2	August 14th 06 02:43 AM
problem with formula	wu-fu	Excel Discussion (Misc queries)	1	July 10th 05 10:22 PM
Problem with formula IF(C5="", "",NOW())	Ruslan	Excel Discussion (Misc queries)	3	February 15th 05 01:07 PM

All times are GMT +1. The time now is 02:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us