How to discover the difference

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

 

[Eduardo]

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

 

[Don Guillett]

How about this
=IF(G5<87,87-G5&" due",IF(G5>87,G5-87&" refund","OK"))

 

[Don Guillett]

Better
=IF(G5<87,DOLLAR(87-G5)&" due",IF(G5>87,DOLLAR(G5-87)&" refund","OK"))

 

[Mike Blakeley]

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 -

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

 

[Mike Blakeley]

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 -

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

 

[Don Guillett]

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 -

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