Calculate Sales Tax and Total Cost

Did you get an #Error as result of your formula ? Was the result erroneous (not the right result) or the formula did simply not work and you couldn’t save your formula field?

I’m simply asking because there is a bug in calculations with a percent

Yes I get an error. my goal is to get the total cost with the sales tax.

I quickly tried this formula :

Cost+Cost/100*{Tax %}

Which gave something looking like this :

Was this what you were looking for ?
(The Cost*Tax% field was just there to verify the math :winking_face: )
The Total Cost is formatted as “Currency”. The Cost is /100 To go around the bug with calculations with percentage.

Cost+Cost/100*{Tax %}

Thank you very much this solved my problem

Would it be possible to make the percentage vary based on the item belonging to a certain category?

I made a check stub for this.

Before, I used to do all this work in Excel, but over time, I realized that it is a waste of time and that there are very good alternatives. I already don’t even remember what formulas I use, and that’s why, unfortunately, I can’t help you with this. But instead, I recommend you make a pay stub. All the fees and taxes you pay on an online pay stub will also be calculated there. It is very simple. All you need is a pay stub generator, and within 2 minutes, your pay stub is ready. I recommend you to try it.

Hey! For the formula, try: Cost + (Cost * (Tax / 100)). That should give you the total.

And yeah, while there are other ways to see taxes and stuff, like maybe on a check stub generator if you're lookin' at income, this formula should work right in your spreadsheet for sales tax.