If Formula Question

S

ScottishSteve

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?
 
F

FSt1

hi
you have the true part in quotes. excel thinks it's text. remove the quotes
and the pound sign i.e.......
=IF(B5="Yes",10.2-B4,"Please complete below")

regards
FSt1
 
P

Pete_UK

You don't need to put the £ sign in front of the 10.20 - just format the
cell as currency to display that. Also, you do not need to put quotes around
the calculation:

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

Hope this helps.

Pete
 
D

David Biddulph

If you want a formula to be evaluated, rather than a text string, throw away
the quote marks.

Change =IF(B5="Yes","£10.20-B4","Please complete below") to
=IF(B5="Yes",10.2-B4,"Please complete below") and format the cell in an
appropriate currency format.
 
Top