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

On Tue, 13 Sep 2005 18:06:52 -0500, picklevote
wrote:


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...


I will make a guess.

I will guess that you are not just entering a value into E49, but that the
value in that cell is the result of some formula. It is likely that the
formula is not really putting a value of zero into E49, but rather it is
entering the TEXT representation of zero.

If that were the case, you would see the results you do, since "0" is greater
than 35 in Excelspeak.

One common error that results in this phenomenon would be a formula like:

=IF(AB,"0","1")

where the proper format, to have NUMBERS as a result, rather than TEXT, would
be:

=IF(AB,0,1)




--ron