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?

If Formula Question
 

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?

If Formula Question
 

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?

If Formula Question
 

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 Formula Question
 

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?