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?

TRY
=10.20-B4
YASEEN
"ScottishSteve" wrote:

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?

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

"ScottishSteve" wrote:

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?

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

"ScottishSteve" wrote in message
...
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?

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.
--
David Biddulph

"ScottishSteve" wrote in message
...
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?