View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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