sales tax calculation formula to produce a chart?

Giganews Newsgroups
Subject: sales tax calculation formula to produce a chart?
Posted by:  Carmensita
Date: Sun, 14 May 2006

I am in field sales and would like to make a chart in Excel that would have a
range of dollar amounts for a 7% rate.  In other words for a one cent tax,
cell A1 would have the minimum value and cell B1 would have the maximum
value. Then for a two cent tax, A2 would have the min. and B2 the max.  I
would copy the formula into other cells to create a chart/table that I could
take into the field.

Replies