Formula not giving correct output

[aakhan2011]

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.

Sheet 1.xlsx - Speedy Share - upload your files here

Thanks in Advance .

Regards,
A.A.K.

 

[Michael M]

I can't view shared sites, but have a look at rounding of values input into B68, C68, D68

Where do these values come from, downloaded, input by others, or from other cells ?
If from any of these, try extending the number of decimal places...this may causing the issue.

 

[eliW]

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.

Sheet 1.xlsx - Speedy Share - upload your files here

Thanks in Advance .

Regards,
A.A.K.

Hi
The number are rounded.

Excel 2010
	A	B	C	D
67	Average	4.8431818	14.9207576	11.2507576
68	Improvement	0.363182	-0.179242	1.020758
Sheet1