Formula not giving correct output

A

aakhan2011

New member
Joined
Jan 16, 2014
Messages
17
Reaction score
0
Points
0
Hi All,

I have a fomula field in row 67 and 68 .Row 67 calculates the average and row 68 calculates the improvement i.e. average(row 68)- last row inserted(row 67). The values for improvements are not showing correct value. C68 seems to give correct value but B68 and D68 is giving wrong value.

B68=4.8-4.5 =0.3 but it shows 0.4
C68=14.9-15.1=-0.2
D68=11.3-10.2=1.1 but it shows 1.0

I am confused, let me know if any clues.

I have attached the sheet also.

View attachment Sheet 1.xlsx

Thanks in Advance .

Regards,
A.A.K.
 
aakhan2011 said:
Hi All,

I have a fomula field in row 67 and 68 .Row 67 calculates the average and row 68 calculates the improvement i.e. average(row 68)- last row inserted(row 67). The values for improvements are not showing correct value. C68 seems to give correct value but B68 and D68 is giving wrong value.

B68=4.8-4.5 =0.3 but it shows 0.4
C68=14.9-15.1=-0.2
D68=11.3-10.2=1.1 but it shows 1.0

I am confused, let me know if any clues.

I have attached the sheet also.

View attachment 2162

Thanks in Advance .

Regards,
A.A.K.
Click to expand...
The results shown are correct. B66 is 4.48 (unrounded figure) and B67 is 4.84. The difference is 0.36 which is rounded to 0.4. Same applies to D68.
This is caused by the rounding of numbers.
 
You must log in or register to reply here.
Back
Top