"AmImad?" wrote in message
...
Hi
I use excel for calculating calibration errors based on range/target
value/actual value, and then round the answers to two decimal places. I
have
noticed some errors where the figures are being rounded too high. Please
see
example below:

Range 0 - 200
Target Value: 100
Input Value: 99.94
Actual error: -0.06
Error as % of range: -0.03
Using the formula: ROUNDUP((((100-99.94)/200)*100),2)
I get the answer -0.04

Can you tell me if I'm doing something wrong?!
Thank you.



Why are you using ROUNDUP? This forces any value greater than 0.03 (greater
even by a minuscule amount) to round UP to the next value, which is 0.04.
You should use the ROUND function.

The result of ((100-99.94)/200)*100), as calculated by my version of Excel,
is 0.0300000000000011, which is quite typical. That's why we bother with
rounding to some sensible number of decimal places. ROUNDUP is the wrong
function to get the right answer for what you want.