[Solved] Decimal places shown affects result

TengoKbailar · Post by **TengoKbailar** » Sat Jul 05, 2014 4:47 am

Hi,
I am entering a number with 5 decimal places into a cell to be multiplied by another cell to give a result with 2 decimal places in a third cell
2.19258 x 3 = 6.58 which is correct

When I set the decimal places in the first cell to 2 although the complete number is still there the result changes to 6.57

Is there a way to have the correct result but only display 2 places in the first cell?

Thanks

Michael

Post by **MrProgrammer** » Sat Jul 05, 2014 5:36 am

Uncheck option Calc → Calculate → Precision as shown.

TengoKbailar · Post by **TengoKbailar** » Sat Jul 05, 2014 7:32 am

Hi Mr Programmer,
That did it Thanks

Michael

[Solved] Decimal places shown affects result

[Solved] Decimal places shown affects result

Re: Decimal places shown effects result

Re: Decimal places shown effects result {SOLVED}