Forum Discussion
Josh Ranew
Jan 26, 2020Copper Contributor
Need help with a formula
I am trying to do the reverse of what I have attached. This is a very basic set of formulas that start with a base premium, then add in a state tax that is the base premium + 2 fees (they can vary ev...
- Jan 26, 2020
Hi Josh Ranew
You may use below formula that will tell base premium on the basis of final premium:
=((C15-C11)/(1+C9+C10))-C7-C8
Revised file is also attached for your reference, hope it will be helpful.
Thanks
Tauqeer
tauqeeracma
Jan 26, 2020Iron Contributor
Hi Josh Ranew
You may use below formula that will tell base premium on the basis of final premium:
=((C15-C11)/(1+C9+C10))-C7-C8
Revised file is also attached for your reference, hope it will be helpful.
Thanks
Tauqeer
- Josh RanewJan 26, 2020Copper Contributor
Thank you so much! I have been beating my head against the wall on this one. I knew it was simple (really simple now that i see it) but I just couldn't get it!
Thanks
- tauqeeracmaJan 26, 2020Iron Contributor
You are most welcome.