I have attached a sample sheet.
I have attempted a formula which does work but not exactly as I intended.
The cells in use are C21 and D21.
I want C21 to have an amount in it £50.00 and when I type £50.00 in D21 I want it to deduct it from C21 and say 'Paid'
Although it works, I want to find out what I have done wrong because it says 'Paid' even if I type in £1.00
Thanks
Change it to
=IF(D21>=50,"Paid",50)
Last edited by Bob Phillips; 07-10-2012 at 04:41 AM.
C21: =IF(D21=50,"Paid",50)
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you very much, that's just what I needed I can see where I went wrong now
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks