Finance
Work out an after-tax amount
=B1*(1-B2)How it works in Excel
- B1 is the amount before tax.
- 1-B2 is the share you keep.
- Real taxes often use brackets, which this simple version ignores.
The idea in general
If 25% goes to tax, you keep 75%.
What I assumed
- The amount is in B1 and the tax rate is in B2.
Check the result on your own data before relying on it.