How to discover the difference

  • Thread starter Thread starter Mike Blakeley
  • Start date Start date
M

Mike Blakeley

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?
 
Hi,
If I understood correctly you will have in let's say column A the cost and
in column B the amount paid, so in column C enter
=A1-B1
This will give you the difference, if negative account has been overpaid

If this was helpful please press yes, Thank you
 
Better
=IF(G5<87,DOLLAR(87-G5)&" due",IF(G5>87,DOLLAR(G5-87)&" refund","OK"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -
Click to expand...

Awesome! you're a genius. Thank you for your help. Mike
 
How about this
=IF(G5<87,87-G5&" due",IF(G5>87,G5-87&" refund","OK"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -
Click to expand...

Thanks Don, actually the first worked better for my purposes. With the
DOLLAR in the equation the result is formatted for currency. Thank you
so much for your response! Mike
 
Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
How about this
=IF(G5<87,87-G5&" due",IF(G5>87,G5-87&" refund","OK"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
message






- Show quoted text -
Click to expand...

Thanks Don, actually the first worked better for my purposes. With the
DOLLAR in the equation the result is formatted for currency. Thank you
so much for your response! Mike
 
Back
Top