Hello,
I think I have a simple question,
How do I create a formula that shows:
1. What's the remaining running balance of the 10,000 in cell B25 after subtracting the amounts from cells C21, and then, and then C22, and then C23, and then C24, and thenC25?
Thank you!!
=$B$25-sum($C$21:C21)
and copy down
to stop any errors
=IF( C21="","", $B$25-sum($C$21:C21))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Wayne,
Thank you for your help!
i have included a snap-shot of what i'm trying to do.
i'd like cell B25 to show a $10,000 balance.
i'd like to show the remaining balance left in cell B25 each time an entry is made in cells C17, C19, C21, F17, F19, F21, or from cells C25 and F25.
ExcelForum.JPG
I think you would need VBA to be able to enter a number and then have that number change
otherwise , if you could get the starting amount from a different cell- it would be simple calculation
B25-(sum( other cells)
Thank you etaf,
but i have no idea what your re[ply meant VBA and B25-(sum(other cells). Sorry, but i'm just learning. I had a co-worker help me with the formula!
Have a great day!
VBA (Visual Basic for Applications) its writing macros
so with a macro , you could read the cell contents of B25 and then change them
But with a formula - you need put a formula into the cell to actually then work on the values - so it can not have 10,000 in it to start , unless the 10,000 is in another cell that the formula is accessing
say for example you have 10,000 in B1
then in B25
you could put
=b1
now B25 shows 10,000
then the formula could be
=B1-Sum(c24:c40)
now it will takes away from 10,000 what ever the sum of C24 to C40 is
does that make a little more sense now?
Yes...thank you!
your welcome, thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks