How To Move Two Decimal Places To The Left On Google Sheets

Viewed 272

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.

2 Answers

multiply it by 0.01

=your_formula_here()*0.01

Alternatively you can divide by 100

=YOURFORMULA()/100
Related