Forum Discussion
DAVIEC6
Apr 18, 2023Copper Contributor
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 t...
HansVogelaar
Apr 18, 2023MVP
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.
- DAVIEC6Apr 18, 2023Copper ContributorThank you soooo much for all your help, that's awesome! Have a super day!