If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to discover the difference
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? |
#2
|
|||
|
|||
How to discover the difference
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? |
#3
|
|||
|
|||
How to discover the difference
How about this
=IF(G587,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? |
#4
|
|||
|
|||
How to discover the difference
Better
=IF(G587,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? |
#5
|
|||
|
|||
How to discover the difference
On Apr 14, 9:45*am, "Don Guillett" wrote:
Better =IF(G587,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 |
#6
|
|||
|
|||
How to discover the difference
On Apr 14, 9:44*am, "Don Guillett" wrote:
How about this =IF(G587,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 |
#7
|
|||
|
|||
How to discover the difference
|
Thread Tools | |
Display Modes | |
|
|