W
William
I've made an Invoice based on one I found in the Templates section. I frequently use the AutoSum feature, which I love, but is there some way I can automatically calculate sales tax in a specified cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Greg Maxey
William,
Lets say your total sales (less sales tax) is in cell c1.
The sales tax rate (say .076) is in c2. Put { =(c1*c2) }
where { } is entered with CTRL+F9 in the cell you want
your total sales tax displayed.
which I love, but is there some way I can automatically
calculate sales tax in a specified cell?
Lets say your total sales (less sales tax) is in cell c1.
The sales tax rate (say .076) is in c2. Put { =(c1*c2) }
where { } is entered with CTRL+F9 in the cell you want
your total sales tax displayed.
Templates section. I frequently use the AutoSum feature,-----Original Message-----
I've made an Invoice based on one I found in the
which I love, but is there some way I can automatically
calculate sales tax in a specified cell?
W
William
Thank you so much!!! Unfortunately, you haven't taken into account the fact that you're speaking to an idiot who also doesn't know how to designate a cell as "cell 1" or "cell 2." Armed with THAT information, I should be able to utilize your tip!!
G
Greg Maxey
William,
I could have provided a better example. The designation
is already done for you. If you have a one column, one
row table the resulting cell is a1. A 4x4 table will have
16 celss with columns a through d and rows 1 through 4.
also doesn't know how to designate a cell as "cell 1"
or "cell 2." Armed with THAT information, I should be able
to utilize your tip!!
I could have provided a better example. The designation
is already done for you. If you have a one column, one
row table the resulting cell is a1. A 4x4 table will have
16 celss with columns a through d and rows 1 through 4.
into account the fact that you're speaking to an idiot who-----Original Message-----
Thank you so much!!! Unfortunately, you haven't taken
also doesn't know how to designate a cell as "cell 1"
or "cell 2." Armed with THAT information, I should be able
to utilize your tip!!
W
William
YAY! This is great, thanks!! What I imagine has to be my LAST hurdle is, I've entered the formula in the field I mentioned (which in this case is f14) as { =(f13*.045)}...or, should it be {f14=(f13*.045)}?...OR, should .045 just kinda be sitting in cell f14, and the formula I enter just be {=(f13*f14)}...and THEN, how do I get it to calculate? Will it just happen as soon as I enter a subtotal in f13, or will I need to click on something, like when I use AutoSum?
Are you sick of this issue yet? I hope not! Thanx!
-William
Are you sick of this issue yet? I hope not! Thanx!
-William
G
Greg Maxey
William,
I am assumming that you are using a simple unprotected
Word document with the total of your sales (less sales
tax) displayed in f13. I further assume you want the
calculated sales tax of your total sales in f14.
Put { =(f13*.45)} in cell f14. Remember { } is entered
with CTRL+F9..
or put .045 (as the tax rate) in f14 and put the following
formula in f15 { =(f13*f14)}
With the method you are using, Word will not perform the
calculation automatically as data is entered. Word will
calculate before you print if you have
File>Print>Options>Update Fields checked. If this is
check, you can quickly update the field by displaying and
then closing print preview. Another way it to right click
the field with the mouse and select update field, or you
and CTRL+a to select all, then F9 to update fields.
There are better ways to do this where the calculation is
in real time. One (probably the most efficient) is to
embed an Excel spreadsheet in the Word document. Another
is to use a Word protected form. With "better" comes more
learning and a new heading "consultaion fees" on your
form. No really, if your are interested, let us know. You
may be satisfied with the method you are setting up now.
mentioned (which in this case is f14) as { =
(f13*.045)}...or, should it be {f14=(f13*.045)}?...OR,
should .045 just kinda be sitting in cell f14, and the
formula I enter just be {=(f13*f14)}...and THEN, how do I
get it to calculate? Will it just happen as soon as I
enter a subtotal in f13, or will I need to click on
something, like when I use AutoSum?
I am assumming that you are using a simple unprotected
Word document with the total of your sales (less sales
tax) displayed in f13. I further assume you want the
calculated sales tax of your total sales in f14.
Put { =(f13*.45)} in cell f14. Remember { } is entered
with CTRL+F9..
or put .045 (as the tax rate) in f14 and put the following
formula in f15 { =(f13*f14)}
With the method you are using, Word will not perform the
calculation automatically as data is entered. Word will
calculate before you print if you have
File>Print>Options>Update Fields checked. If this is
check, you can quickly update the field by displaying and
then closing print preview. Another way it to right click
the field with the mouse and select update field, or you
and CTRL+a to select all, then F9 to update fields.
There are better ways to do this where the calculation is
in real time. One (probably the most efficient) is to
embed an Excel spreadsheet in the Word document. Another
is to use a Word protected form. With "better" comes more
learning and a new heading "consultaion fees" on your
form. No really, if your are interested, let us know. You
may be satisfied with the method you are setting up now.
LAST hurdle is, I've entered the formula in the field I-----Original Message-----
YAY! This is great, thanks!! What I imagine has to be my
mentioned (which in this case is f14) as { =
(f13*.045)}...or, should it be {f14=(f13*.045)}?...OR,
should .045 just kinda be sitting in cell f14, and the
formula I enter just be {=(f13*f14)}...and THEN, how do I
get it to calculate? Will it just happen as soon as I
enter a subtotal in f13, or will I need to click on
something, like when I use AutoSum?
G
Greg Maxey
William,
By the way, how are you numbering your invoices? See:
http://www.mvps.org/word/FAQs/MacrosVBA/NumberDocs.htm
mentioned (which in this case is f14) as { =
(f13*.045)}...or, should it be {f14=(f13*.045)}?...OR,
should .045 just kinda be sitting in cell f14, and the
formula I enter just be {=(f13*f14)}...and THEN, how do I
get it to calculate? Will it just happen as soon as I
enter a subtotal in f13, or will I need to click on
something, like when I use AutoSum?
By the way, how are you numbering your invoices? See:
http://www.mvps.org/word/FAQs/MacrosVBA/NumberDocs.htm
LAST hurdle is, I've entered the formula in the field I-----Original Message-----
YAY! This is great, thanks!! What I imagine has to be my
mentioned (which in this case is f14) as { =
(f13*.045)}...or, should it be {f14=(f13*.045)}?...OR,
should .045 just kinda be sitting in cell f14, and the
formula I enter just be {=(f13*f14)}...and THEN, how do I
get it to calculate? Will it just happen as soon as I
enter a subtotal in f13, or will I need to click on
something, like when I use AutoSum?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.