Home > database >  Google Sheet calculation uses math result value instead of displaying value issue
Google Sheet calculation uses math result value instead of displaying value issue

Time:11-30

I am not sure if I am on right platform to ask this question, if not please suggest.

I have this calculation in my sheet and it is correct: 39.13 * 84 = 3286.92

But when I want to get 39.13 via formula I face with the next issue:

The formula looks like this:

Cell A1 =(45 - 33.25) / 2 the result is 5.875

Cell A2 =(A1 33.25) * 84 the result is 3286.5 which is different to the result 3286.92 above.

The problem is that I used financial number formatting and on my Google sheets I see not 5.875, but 5.88. Which is correct if we say about visual as it rounded for me as for viewer but not for the sheet internally.

Looks like when a sheet does calculation it ignore visual formatting. Just assumption.

And it uses not displaying value 5.88 but 5.875 which is result of calculation in A1 cell above. I bet it works as I say.

Which is mathematically of course correct as well, but my question how can I make A1 cell's result to be not just displayed as financial string but also to be used as 5.88 in next calculations?

CodePudding user response:

in A1 try:

=ROUND((45 - 33.25) / 2; 2)

you can replace ROUND to ROUNDDOWN, ROUNDUP, MROUND or TRUNC depending on how you want to treat decimals

  • Related