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