I am trying to set up a sheet that has General sales Tax on it. Now in one
colume i would like to put the subtotal then the next colume I would like for
it to automaticlly add the 6% GST and then the next colume have the total of
those two columes.

Thanks for your help.
--
Treen

Put the pre-tax price in A1
In B1 enter =A1*6% to compute the tax
In C1 enter =A1+B1 to compute the after-tax price
Copy these formula down the columns
If you are using Excel 2003, the formulas will be automatically insert if
you have a table with about 5 rows of formulas.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Trina" wrote in message
...
I am trying to set up a sheet that has General sales Tax on it. Now in one
colume i would like to put the subtotal then the next colume I would like
for
it to automaticlly add the 6% GST and then the next colume have the total
of
those two columes.

Thanks for your help.
--
Treen

Thanks so much. That did what I needed it to do. Now I can just copy and
paste for the rest of the days of the month. Your the best, thanks again.
--
Treen


"Bernard Liengme" wrote:

Put the pre-tax price in A1
In B1 enter =A1*6% to compute the tax
In C1 enter =A1+B1 to compute the after-tax price
Copy these formula down the columns
If you are using Excel 2003, the formulas will be automatically insert if
you have a table with about 5 rows of formulas.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Trina" wrote in message
...
I am trying to set up a sheet that has General sales Tax on it. Now in one
colume i would like to put the subtotal then the next colume I would like
for
it to automaticlly add the 6% GST and then the next colume have the total
of
those two columes.

Thanks for your help.
--
Treen

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/

Don't forget you can use autofill rather than copy & pasting: move your
cursor to the bottom right hand corner of the cell that contains the formula
you want to copy (it should become a 'skinny' cross +) and double click.
Excel will 'fill' the same number of rows as the column to the left with your
formula changing cell references (ie A1 becomes B1 etc).

I presume this still works in 2007 but don't know as I don't have it :-)

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

If this post answered your question please let us know as others may be
interested too


"Trina" wrote:

Thanks so much. That did what I needed it to do. Now I can just copy and
paste for the rest of the days of the month. Your the best, thanks again.
--
Treen


"Bernard Liengme" wrote:

Put the pre-tax price in A1
In B1 enter =A1*6% to compute the tax
In C1 enter =A1+B1 to compute the after-tax price
Copy these formula down the columns
If you are using Excel 2003, the formulas will be automatically insert if
you have a table with about 5 rows of formulas.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Trina" wrote in message
...
I am trying to set up a sheet that has General sales Tax on it. Now in one
colume i would like to put the subtotal then the next colume I would like
for
it to automaticlly add the 6% GST and then the next colume have the total
of
those two columes.

Thanks for your help.
--
Treen

Stan:
Tools | Options | Edit; check the box Extend Data Range Formats and Formulas
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Stan Brown" wrote in message
t...

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?

--

Mon, 23 Apr 2007 09:14:31 -0300 from Bernard Liengme
:
Stan:
Tools | Options | Edit; check the box Extend Data Range Formats and Formulas
best wishes

Already set, but neither formulas nor formats are propagated.
And yes, I meet the "three out of five" rule: I've got about thirty
rows, all with identical formulas and formats. But the formulas and
formats don't carry forward when I enter values in the next row.

--
If you e-mail me from a fake address, your fingers will drop off.

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