On Apr 14, 9:45*am, "Don Guillett" wrote:
Better
=IF(G5<87,DOLLAR(87-G5)&" due",IF(G587,DOLLAR(G5-87)&" refund","OK"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Mike Blakeley" wrote in message

...



I am creating a worksheet and I can't quite get the formula to work.
I want to compare two numbers and see if they are equal to, less than
or greater than a constant integer. For instance...if it costs $87.00
for Limo but Sally has paid $100.00 how much is she due? *or if Roger
has paid $70.00 but the Limo costs $87.00 how much does he owe?

Any suggestions?- Hide quoted text -

- Show quoted text -

Awesome! you're a genius. Thank you for your help. Mike