Forum Discussion
Formula to back tax out
I have a spreadsheet with the total including taxes in Column D2 and I want to show the pretax amount in Column B2 and show the tax separate in Column C2. I need help writing the formula to perform that task, can someone please help me.
Let's say the tax rate (a percentage) is in cell K1.
In B2:
=100%/(100%+$K$1)*D2
In C2:
=$K$1/(100%+$K$1)*D2
The formulas can be filled or copied down to the cells below, if required.
- Thank you soooo much for all your help, that's awesome! Have a super day!
