Sun, 22 Apr 2007 16:40:31 -0300 from Bernard Liengme
:
Put the pre-tax price in A1
In B1 enter =A1*6% to compute the tax

The OP wants either =ceiling(a1*.06,.01) or =round(a1*.056,2),
depending on the tax laws in that jurisdiction. For example, in Ohio
it's "ceiling" but in New York it's "round". (In both it's more than
6%.

If you are using Excel 2003, the formulas will be automatically insert if
you have a table with about 5 rows of formulas.

Really? I have a couple of worksheets that are long columns of
formulas, and have to insert the formulas manually when I add rows.
Is there some option I should set?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/