G
Guest
0.02778
2.8 this cell = 100X cell above
1.0
1.138 this cell = power(cell above- cell 2above, 2)/(cell 2 above)
should be (-1.8^2)/2.8=1.157
version excel 2002 (10.4521.4219)SP2
this is very worrying,
I also did ((B8-B6)*(B8-B6))/B6 gave same wrong answer
Any ideas ??
2.8 this cell = 100X cell above
1.0
1.138 this cell = power(cell above- cell 2above, 2)/(cell 2 above)
should be (-1.8^2)/2.8=1.157
version excel 2002 (10.4521.4219)SP2
this is very worrying,
I also did ((B8-B6)*(B8-B6))/B6 gave same wrong answer
Any ideas ??