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