# Thread: Calculate gross after net less a tax rate

1. ## Calculate gross after net less a tax rate

This is probably a very simple formula, but having a brain-fart.

I'm looking to obtain the gross amount of a given net number after 20% is withheld.

Thanks!
KZ

2. KZ,

=Net/(GrossPct*100)*100

=80/(0.8*100)*100 Will = 100.

You may want to enclose it in a round function, e.g. =Round(formula-here,2)

CZNet.JPG

HTH

3. If amount is in say A2 is 1000 and % in B2 (is 20%), then formula in C2 would be = A2* (1-B2). This will equate to 1000 * (1-0.20) = 800

4. Thanks. So, in your formulas with =ROUND(C2/(B2*100)*100,2) I'd like the B2 cell to be 20, and not the offset using 80. What would the formula look like to put the 20 or 0.2 in B2?

5. Net/(100%-discount) OR Net/80% OR Net/.8

HTH,
Maud

discount.png

6. Maudibe, that's even easier! However, I'd like to use 20% (.20) not .80. Any way to convert that so I can use that number?

7. Hi

..if your withholding tax is 27.5% then, the formula is
=A2/(1-27.5%)

..if your withholding tax is 20% then, the formula is
=A2/(1-20%)

..you can enter the tax percentage number as 20%; you don't need to enter it as .20 if you don't want to.

zeddy

8. Net/(100%-discount)
Net/(100%-20%)

9. Thanks everyone. That works perfect now.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•