Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amount Owing
I have a total cell all the input is add to this point. I want to know how
to make an amount owing cell...how do I put the fixed amount in so it will be subtracted by the total cell. I am sorry if this is not clear. I am using office 2003 on XP. Any help would be great. And as if you can't tell I am a very new user to Excel. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amount Owing
Let's say your total cell is in A4, and has a formula similar to this:
=SUM(A1:A3) You're goal that you are wanting to reach, the "fixed amount" is in A5. The amount left that you owe then is: =A5-A4 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "LAM" wrote: I have a total cell all the input is add to this point. I want to know how to make an amount owing cell...how do I put the fixed amount in so it will be subtracted by the total cell. I am sorry if this is not clear. I am using office 2003 on XP. Any help would be great. And as if you can't tell I am a very new user to Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change amount in figure to amount in words? | Excel Worksheet Functions | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
employee annual sick leave tracker with hours owing not used | Excel Discussion (Misc queries) | |||
How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions |