|Subject:||sales tax calculation formula to produce a chart?|
|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.