View Single Post
  #1   Report Post  
rbp
 
Posts: n/a
Default 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