View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Calculating gross when net is known

Well, it depends what your tax rate is. Suppose it is 10% (i.e. 0.1),
then:

Net * 1.10 = Gross

Hence,

Net = Gross / 1.10

or:

Net = Gross / (1 + tax_rate)

Hope this helps.

Pete

On Dec 18, 5:21*pm, placerpone
wrote:
Frequent budget adjustments when the gross amount of the adjustment is know.
I need to calculate backwards for the tax burden to come up with the net