Help with an IF formula please.
 

I have the following formula in a spreadsheet. Any value I use in the M
column works EXCEPT F10. For some unknown reason, the formula still
appears to be good, but does not return a true answer.


=IF($M3="F10",72.4+2.7,IF($M3="F11",72.4+2.7,IF($M 3="F12",72.4+2.7,0)))


I will greatly appreciate any help!

Thanks.


--
rbp
------------------------------------------------------------------------
rbp's Profile: http://www.excelforum.com/member.php...o&userid=20456
View this thread: http://www.excelforum.com/showthread...hreadid=385401

rbp,

What value is it returning when you put "F10" in column M? I assume you
want it to return 75.1 (72.4+2.7).

Eric


"rbp" wrote:


I have the following formula in a spreadsheet. Any value I use in the M
column works EXCEPT F10. For some unknown reason, the formula still
appears to be good, but does not return a true answer.


=IF($M3="F10",72.4+2.7,IF($M3="F11",72.4+2.7,IF($M 3="F12",72.4+2.7,0)))


I will greatly appreciate any help!

Thanks.


--
rbp
------------------------------------------------------------------------
rbp's Profile: http://www.excelforum.com/member.php...o&userid=20456
View this thread: http://www.excelforum.com/showthread...hreadid=385401

rbp,

I get 75.1 if M3 contains "F10". Try this: with the formula selected,
highlight the $M3, then press F9 (calculate). You should see "F10" in its
place. Press Esc, not Enter, or the formula will be changed to what's in
the formula bar now.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"rbp" wrote in message
...

I have the following formula in a spreadsheet. Any value I use in the M
column works EXCEPT F10. For some unknown reason, the formula still
appears to be good, but does not return a true answer.


=IF($M3="F10",72.4+2.7,IF($M3="F11",72.4+2.7,IF($M 3="F12",72.4+2.7,0)))


I will greatly appreciate any help!

Thanks.


--
rbp
------------------------------------------------------------------------
rbp's Profile:
http://www.excelforum.com/member.php...o&userid=20456
View this thread: http://www.excelforum.com/showthread...hreadid=385401

What exactly is F10 - 11 - 12?
Are they just "Text Data"?
Or maybe, cell addresses?
Also ... If they're *IN* M3, how do they get there? Keyed in ... results of
other formulas ... imported from other apps?
--
Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"rbp" wrote in message
...

I have the following formula in a spreadsheet. Any value I use in the M
column works EXCEPT F10. For some unknown reason, the formula still
appears to be good, but does not return a true answer.


=IF($M3="F10",72.4+2.7,IF($M3="F11",72.4+2.7,IF($M 3="F12",72.4+2.7,0)))


I will greatly appreciate any help!

Thanks.


--
rbp
------------------------------------------------------------------------
rbp's Profile:
http://www.excelforum.com/member.php...o&userid=20456
View this thread: http://www.excelforum.com/showthread...hreadid=385401

Thanks For The Help.


--
rbp
------------------------------------------------------------------------
rbp's Profile: http://www.excelforum.com/member.php...o&userid=20456
View this thread: http://www.excelforum.com/showthread...hreadid=385401