Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
excel running balance sheet formulas?
I know the numbers I need in each cell.. but cant figure out the formulas that need to go in the second column.
First column, we put in the numbers manually. But second column is where the calculations come in.
Row ------ Column A ----- Column B
1 ------- 2444.44 ----- =a1
2 ------- 4888.88 ----- 2444.44 (this is 2444.44 because we already paid the person 2444.44 in B1.. they ended up earning more 4888.88, so B2 needs to be the difference of what is owed
3 ------ 1000.00 ------ (3888.88) in B3 shows since 4888.88 has been paid out already.. but the new total they earned is only $1000.. so B3 indicates how much they need to pay back
4 ----- 2666.68 ----- (1222.20) in B4 since they had a negative balance the previous month B3.. but now they earned more (a4)... b4 indicates they owe less back.
5 ----- 2000.00 ------ 777.80
6 ----- 500.00 ----- (277.80)
This is a complicated mess in my opinion. But it is part of a complicated commission calculation that works on a percentage made each month.. but also that percentage is then used to calculated how much should be given out over the course of the year.
Column A shows the commission amount earned that month and needs to be compaired with what was already paid out. I think the system if flawed.. but non the less, this is how they want it recorded. I need a formula for column B that makes the numbers I put in work out each time, regardless if column A is more or less than the previous month.
1 Answer
- expletive_xomLv 77 years agoFavorite Answer
something is not right with he sample logic
if a person earns 4888.88 (A3) thats cool
if the person earns an extra 1000 (A4) the next month.....then why does the person have to pay back 3888.88?
assume the logic is correct
then if a person earns 2000 (A5) acceptable
if the person earns an extra 500 (a6) the next month....then why doesnt the person have to pay back 1500?
the logic is not consistent.
it seems like A2 earned 4888.88.....but then had some sort of expenses to pay and the annual amount earned dropped to 1000 shown in A3.....you might want a separate column showing the expense.
speaking of separate columns.
you need a column for Amount earned....a 2nd column for amount paid.....then your 3rd column should calculate what you need.....you should also have a column for that calculated commission percentage earned.
remember....you always can hide the columns if you are not allowed to show them for your report (thats called "presentation purposes")