Google Sheets – Fix Wrong Value of Multiplication and Division

google sheets

I have 4 cells, O4, P4, Q4 and R4:

O4 P4 Q4 R4
1.0 1.0 1.7 = (O4+P4+Q4)*10

The result should be 37 but Google Sheets returns 30.1. If I write /10 instead of *10, I get 24.2 but it should be 0.37. What went wrong there?

Best Answer

Thanks to @ErikTyler, I found that the value displayed as "1.7" was actually a "01/07/2021". I have no idea why the sum is still correct but the multiplication isn't and why Google Sheets interprets it as such but at least I could fix the error by changing it to a real "1.7".

Related Topic