Excel Percentage Calculation

[THMarana]

I want to be able to change the benefit % in E4 and have it recalculate the correct dollar amount of benefits. Thank you in advance for your help.

 

[THMarana]

In example 1, to find the percentage in C4, when all other data is known, I used =D4/D5 to find the percentage 31.7602. Is that incorrect?

 

[Cubist]

I told you that the result is incorrect therefore whatever is in cell C4 is not D4/D5. You're not doing D4/D5. Click in the cell, send screenshot of the formula.

 

[THMarana]

You said it's D4/D5 but it doesn't look like you did. Click in C4 and see if the cell references are correct.

They are, thank you.

 

[THMarana]

I developed a formula that solves the problem and I wanted to share it with the community because I know a lot of people have the same question.

The formula is "=(B7/100)*C6", this will allow manual change of the benefit percentage, and recalculate the annualized benefit dollars. (FYI, I did change C4 to numerical vs. percentage; otherwise, the percentage would display 3176.02%).

I want to thank you again for your assistance, when we could not come up with a solution it strengthened my resolve to solve it.

Reply Edit

 

[shift-del]

The formula is "=(B7/100)*C6",

On your screenshot both cells are empty.