This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I never deal with formulas as they are too hairy for me, but with California sales tax going up every other day, I have to ask:
I have an excel file that list dollar amount sales and then the next column has the sales tax (which I do by hand calculator)
How does one make it so that column always would multiply by 0.975%?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Assume your Dollar amount is in A and the sales tax column is in in column B. then the formula in B1 is: =a1*.0975 enter this, and then fill down for as many rows as needed.
Answer accepted by question author
Kevs, as you must have learned by now, nothing is too complicated for Excel.
The formula you want is: in C1, the formula is =A1+B1
Now, if you want this rounded as you specified,and you are only want integers, not fractions then the formula becomes: =if(a1+b1-int(a1+b1)>.3,int(a1+b1)+1,int(a1+b1))
and, in column D and E, the formula is =C1/2
I never deal with formulas as they are too hairy for me, but with California sales tax going up every other day, I have to ask:
I have an excel file that list dollar amount sales and then the next column has the sales tax (which I do by hand calculator)
How does one make it so that column always would multiply by 0.975%?
I'm working on creating Sales and Use Tax Templates for the ease of reporting. There is more to
reporting the tax than just calculating sales tax from gross sales. What kind of business are you
reporting the tax for? The templates I have are for retail but I'm able to change that up to
accommodate other types of business.
What you do is enter your gross sales and exempt sales and the template does the rest for you.
There is a column with the current rates (as of 4/1/2016). When there is a rate increase (or decrease)
California just had some decreases too you have to change the rates accordingly. The template is
pretty easy to use though. The data you enter does the calculating for you and flows to the
sales tax return.
If this would be helpful to you let me know.
Got it Bob, very impressive! thanks.
Thanks Bob,
The other thing I do which is add up A and B into C. Do you know the formula for that?
Then, and this may be real complicated for Excel, I round off to my favor to the higher number if the number is higher than .3 and round lower that point. 3
For example 10.4 I round to 11, but 10.2 I round to 10
And then in columns D and E, I put 1/2 totals in each ( deposit and the due)