Errors with ROUND function
Posted on 1997-12-04
I have a onCalculate procedure where two (FLOAT)fields from table are multiplied, the result is put into the calc field type FLOAT. Now I have to round this to the nearest integer... 0.00-0.49 -> 0.00
0.50-0.99 -> 1.00 right?
Well when 1.5 is multiplied by 1 I get 2 (i.e. round(1.5*1)=2), when 1.5 is multiplied 3 I get 4 (round(1.5*3) = 4) when I know I should get 5.
This happens on several different machines, but not in EXCEL.
So what gives is there another way to round this equation and get a expected result?
Please help soon