Ok I'm rather new at Excel (what I do know has been self taught) but now I need help. I've tried for a couple years to figuare out how to do the following with no luck.
I need to add 67% to the base rate for some insurance quotes. For example Mr. Smith's base rate is $250. According to state law the insurance company can add up to 67% to the base rate for his monthly premium. I want to give Mr. Smith a 'worse case scenerio' how do I get Excel to do this for me?
In reality I have to do this to over 250 employees in a group and don't want to manually figuare each one - it takes forever!
Thank for the help in advance!
I need to add 67% to the base rate for some insurance quotes. For example Mr. Smith's base rate is $250. According to state law the insurance company can add up to 67% to the base rate for his monthly premium. I want to give Mr. Smith a 'worse case scenerio' how do I get Excel to do this for me?
In reality I have to do this to over 250 employees in a group and don't want to manually figuare each one - it takes forever!
Thank for the help in advance!