C
calv1n
I am creating a monthly budget worksheet. It divides my deposits int
seperate categories dependent on how much money I have projected that
need for the month. (Cellphone = $50, Food = $400 etc) .
I wanted to create a feature that once each category has been filled.
So say my deposits have put in a total of $50 into my cellphone account
the remainder would be put into saving to pay off debt.
In creating this, I made cell
D100 the fixed amount ($50).
E100 = the percent that went from my paycheck
G100 = the amount I have saved so far this month.
=(E100+G100)
H100 = An IF statement that will show how much has gone into paying of
debt from this account.
=IF(D100 > F100,G100-D100,"Budget not met")
My problem is obvious.... How do I create G100 without it being
circular argument? I tried to change the iterations to 1. But it go
ugly, and added when I clicked into a cell or saved. So I am lookin
for a function to get around this circular argument...THANK YOU I
ADVANCE!!!
:
seperate categories dependent on how much money I have projected that
need for the month. (Cellphone = $50, Food = $400 etc) .
I wanted to create a feature that once each category has been filled.
So say my deposits have put in a total of $50 into my cellphone account
the remainder would be put into saving to pay off debt.
In creating this, I made cell
D100 the fixed amount ($50).
E100 = the percent that went from my paycheck
G100 = the amount I have saved so far this month.
=(E100+G100)
H100 = An IF statement that will show how much has gone into paying of
debt from this account.
=IF(D100 > F100,G100-D100,"Budget not met")
My problem is obvious.... How do I create G100 without it being
circular argument? I tried to change the iterations to 1. But it go
ugly, and added when I clicked into a cell or saved. So I am lookin
for a function to get around this circular argument...THANK YOU I
ADVANCE!!!
: