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