View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ScottishSteve ScottishSteve is offline
external usenet poster
 
Posts: 7
Default If Formula Question

Hi,

I need some help creating an IF formula incorporating the following info:

=IF(B5="Yes","£10.20-B4","Please complete below")

The part that isnt working for me just now is the TRUE return. I need it to
be £10.20 minus the monetary amount already entered in B4.

Any suggestions?