Antonio Vernucci wrote:
But give A1 any non-zero value and see what happen.

It appears that EXCEL uses the Microsoft BASIC engine
for its calculations. Those problems are well understood
by BASIC users. Hint: use more parentheses.
--
73, Cecil, IEEE, OOTC, http://www.w5dxp.com