Help with an IF formula please.

[rbp]

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($M3="F12",72.4+2.7,0)))


I will greatly appreciate any help!

Thanks.

 

[Guest]

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

 

[Earl Kiosterud]

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.

 

[RagDyer]

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?

 

[rbp]

Thanks For The Help