ExcelBanter - Amount Owing

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Amount Owing (https://www.excelbanter.com/excel-worksheet-functions/248832-amount-owing.html)

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.

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.