Thread: Tax rates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default Tax rates

Maybe something like:

=150*17.5% = 26.25
=150*5% = 7.5
=150+(150*17.5%) = 176.25
=150+(150*5%) = 157.5
or
=150+(150*22.5%) = 183.75

HTH
JG

"PJOS11" wrote:

HI I have just began to use Excel for invoices. I have set my Tax rate at
17.5%. but we use two tax rates here, the other is 5%.
How can I do this on one invoice.
Eg: 150+17.5%
150+5%