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

"Mike Blakeley" wrote:

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?

How about this
=IF(G5<87,87-G5&" due",IF(G587,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?

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?

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

On Apr 14, 9:44*am, "Don Guillett" wrote:
How about this
=IF(G5<87,87-G5&" due",IF(G587,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 -

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

"Mike Blakeley" wrote in message
...
On Apr 14, 9:44 am, "Don Guillett" wrote:
How about this
=IF(G5<87,87-G5&" due",IF(G587,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 -

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