View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Calculating gross when net is known

Hi,
I am lost here usually you have your gross less your taxes = Your net

assuming gross is in a1, tax in b1(calculated based on 10% taxes) in c1 the
net will be

=a1-b1

Now if you know your net to get your gross will be

=c1/0.90

0.90 comes from 1-0.10 taxes



"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