Trevor - Round Up/Down ?

T

TQ

Hi Trevor,

Thanks for reply.If I insist F2 cut off with 4 decimal points,get the answer
by $12,151.41 any formula or solution ?

Thanks !



F2 is actually 18.218016

The result is: 12151.416672

On my calculator, if I multiply 18.218016 by 667, I get 12151.416 but it
only displays 8 digits. I'm surprised that my calculator appears to have
truncated rather than rounded up but there you go.

Looks like Excel got the calculation right. You need to put more decimal
places into the calculator if you want to compare the output.

Regards

Trevor
 
Top