If Formula Question

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

 

[Yaseen Al-Lawati]

TRY
=10.20-B4
YASEEN

 

[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

 

[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

 

[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.