Removing Tax Component
 

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

Removing Tax Component
 

Is there any reason not to use =A1/(1+10%) ?
--
David Biddulph

"Browny" wrote in message
...
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

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

Removing Tax Component
 

Thanks Guys
They work
i worked it out and used. =(A1-(A1/11)
--
Browny


"Sheeloo" wrote:

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

Removing Tax Component
 

=ROUND(A1-(A1*10%/110%),2)

--
__________________________________
HTH

Bob

"Browny" wrote in message
...
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