Thread: calculate taxes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default calculate taxes

Looks like Provincial/State tax and Federal GST

The taxes are not compounded, so just add them together and tack onto the
selling price.

=A1+(A1*.13)


Gord Dibben MS Excel MVP

On Wed, 6 Sep 2006 16:24:01 -0700, B.W. wrote:

I have columns of sale items that need to have two taxes 7% & 6% added to
them. I can do one by but not sure how to combine them. ie 100+7+6=113. What
is the formula for this. I am relatively new to this.