I'm using google sheets to calculate sales tax for items our company is selling, but when I try and get the total sales tax, it produces it into a large number.

For example, I'm selling an item for $89.26, at a tax rate of 10.25%. The total should be 9.14915, and if it's rounded - would be 9.15

But the total that pops up at the moment is 915.

I'd like to know how to get the desired 9.15 and not 915

If anyone can help that would be great,

Thank you.

CodePudding user response：

multiply it by 0.01

=your_formula_here()*0.01

CodePudding user response：

Alternatively you can divide by 100

=YOURFORMULA()/100