View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Removing Tax Component

In B1 enter the formula =A1/(1+r/100) whre r is the rate of tax (r =10 if tax
rate is 10%)

"Browny" wrote:

I wish to remove the tax component (10%) from an invoiced amount.
I can do it in two steps, but i'd like it done in one.
i.e A1 B1
$120.00 $109.09
Browny