| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office web component . | Excel Worksheet Functions | |||
| Activex component can't create object | New Users to Excel | |||
| Web Excel Component Bug | Excel Discussion (Misc queries) | |||
| office web component error | Excel Discussion (Misc queries) | |||
| Calling .net Component from Excel Macro | Excel Discussion (Misc queries) | |||
Linear Mode
