Formula not giving correct output

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.
 

peter.abing

New member
Joined
Oct 24, 2012
Messages
34
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 2162

Thanks in Advance .

Regards,
A.A.K.
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.
 
Top