GST

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trina - 22 Apr 2007 20:22 GMT

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.

Signature

Treen

Reply to this Message

Bernard Liengme - 22 Apr 2007 20:40 GMT

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

Signature

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

>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
[quoted text clipped - 4 lines]
>
> Thanks for your help.

Reply to this Message

Trina - 23 Apr 2007 03:32 GMT

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.

Signature

Treen

> Put the pre-tax price in A1
> In B1 enter =A1*6% to compute the tax
[quoted text clipped - 11 lines]
> >
> > Thanks for your help.

Reply to this Message

aneasiertomorrow - 23 Apr 2007 10:10 GMT

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

Signature

MOS Master Instructor
www.aneasiertomorrow.com.au

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

> 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.
[quoted text clipped - 14 lines]
> > >
> > > Thanks for your help.

Reply to this Message

Stan Brown - 23 Apr 2007 05:34 GMT

Sun, 22 Apr 2007 16:40:31 -0300 from Bernard Liengme
<bliengme@stfx.TRUENORTH.ca>:

> 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?

Signature

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

Reply to this Message

Bernard Liengme - 23 Apr 2007 13:14 GMT

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

Signature

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

>> If you are using Excel 2003, the formulas will be automatically insert if
>> you have a table with about 5 rows of formulas.
[quoted text clipped - 4 lines]
>
> --

Reply to this Message

Stan Brown - 24 Apr 2007 01:02 GMT

Mon, 23 Apr 2007 09:14:31 -0300 from Bernard Liengme
<bliengme@stfx.TRUENORTH.ca>:

> 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.

Signature

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

Reply to this Message

Rate this thread: