Using the following formula =IF(E49=35,"APPROVED","APPROVAL REQUIRED")
I'm trying to return a Value of "APPROVAL REQUIRED" if the value of E49
falls between zero 0 and 35; instead if the value is zero, i'm getting a
value of "APPROVED" . The formula works fine and returns a value of
"APPROVAL REQUIRED" if the value of E49 falls between1 and 35, and
changes automatically to "APPROVED" if higher than 35, but for some
strange reason, an E49 value of zero (which in my maths book is less
than 35) returns a value of "APPROVED" Why? I really have
tried everything I can think of and am now completely knackered and
frustrated - Hopefully some wizard can help me...


--
picklevote
------------------------------------------------------------------------
picklevote's Profile: http://www.excelforum.com/member.php...o&userid=27219
View this thread: http://www.excelforum.com/showthread...hreadid=467346