GST

[Guest]

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.

 

[Bernard Liengme]

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

 

[Guest]

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.

 

[Stan Brown]

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?

 

[Guest]

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

 

[Bernard Liengme]

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

 

[Stan Brown]

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.