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
Josh Ranew
Jan 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
tauqeeracma
Jan 26, 2020Iron Contributor
You are most welcome.