Here are some problems that our users have asked and received explanations on
Stop rounding numbers, permanently and globally.
Solved by M. J. in 27 mins
need help totaling values in one column and rounding down in another
Solved by F. F. in 20 mins
Hi With excel my result is 1.932% and with a calculator it is 1.924. Can you explain the difference. I have tried rounding up and down but cannot get the same answers
Solved by Z. L. in 14 mins
How do I get a column to add up exactly the values rather than rounding up to the nearest pound?
Solved by F. F. in 28 mins
I want to give insulin in 0.5 unit intervals but standard rounding rules do not apply. For example, 0.0 to 0.3 rounds to 0 units; 0.4-0.7 rounds to 1/2 unit; 0.8-1.3 rounds to 1 unit. How can I tell excel this