What type of formula do I have to write to show a value in one cell then deductions in the next cell. I want to keep a value in cell A1 then in b1, b2, b3,b4 etc the amount taken from cell A1 so it shows my remaining balance.
Thank you
What type of formula do I have to write to show a value in one cell then deductions in the next cell. I want to keep a value in cell A1 then in b1, b2, b3,b4 etc the amount taken from cell A1 so it shows my remaining balance.
Thank you
Maybe =A1-10
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello, What I'm looking to do is some type of inventory deductions. I have a starting value say $5,000.00 in cell A1. Payments come in every week so I want to enter the payments line by line. I want to see each payment deducted from the $5,000.00.
Is this possible?
Thanks,
Upload a sample workbook
Hello FDibbins,
Thanks for your help, I've been assigned another project and will have to come back to this. However I do have a new question, not sure if you can help or if I should post it to the forum.
thanks!!
Sure post in a new thread and lets see how we can help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks