I just need these formulas for Excel. 4) Row 17 needs an IF statement, if your p
ID: 3903446 • Letter: I
Question
I just need these formulas for Excel.
4) Row 17 needs an IF statement, if your parents retire (a "R" in Row 10) the tax rate is: .15 otherwise if they continue working the tax rate is .30 5) Row 18 needs an IF statement, if your parents retire the cost of living is: Row 6 - 15000 otherwise it is Row 6 6) Row 20 needs an IF statement, if your parents stay in their home (Cell C11 = "Y") they must pay the home association fees shown in Row 7, otherwise 0. 7) Row 23 (beginning of year cash) equals the end of the year cash for the prior year. 8) Row 32 (income tax), if your parents have a positive income before taxes (i.e. > 0), multiply their income before taxes times the tax rate in Row 17, otherwise no taxes are due if your income is negative. 9) Save your work! ` 10) Create the scenario as described below. 11) Your changing cells for all scenarios are: C10 to H10 and C11, the result cell is H14 12) Name your first scenario "Retire Early/Stay" with these values: R, R, R, R, R, R, Y 13) Name your 2nd scenario "Retire Early/Move" with these values R, R, R, R, R, R, N 14) Name your 3rd scenario "Delay/Stay" with these values W, W, W, R, R, R, Y 15) Name your 4th scenario "Delay/Move" with these values W, W, W, R, R, R, NExplanation / Answer
4)
In Row17 , type if statement :
=IF(A10="R",0.15,0.3)
As, whether a parent is retire or not is stored in Row10 therefore compare A10 with "R" .
If A10 is equal to "R" then tax rate displayed will be 0.15 else 0.3
To repeat same formula in entire row17 drag along the row17
5)
If statement will be:
=IF(A10="R",A6-15000,A6)
as whether parent is retire or not is stored in row10 therefore compare A10 with "R"
if parent is retire then we have to store value Row6-15000 in row 18 else store value in row6 in row18.
Row6 is defined by A6.
Drag the formula in entire row 18 to get value in all cell of row 18
6)
Suppose home association fees is stored in C7 .
If parent stay in home i.e. C11="Y" then they must pay home association fees.
So, formula becomes
=IF(C11="Y",C7,0)
7)
Suppose end of year cash for prior year is stored in row13 then row23 gets formula :
= A13