On Sun, 5 Feb 2006 10:53:28 -0800, "Shamroq"
wrote:

typical:
Cell A1 I have 0.2
Cell B1 I have 0.22
Cell C1 I have formula : +(B1-A1), and the answer is 0.02, correct
However, in Cell D1, I have a formula: +Power(c1,2), and the answer is
0.0005, WRONG,
The correct answer is of course 0.0004, but all simailar calculations are in
error.
I even put in the formula for D1 as +(c1*c1) and I still get the same WRONG
answer. Please advise

Most likely, you don't really have 0.2 in A1 and/or 0.22 in B1.

Are these values the results of formulas? If so, then you are seeing a rounded
result, which does not truly reflect the contents of those cells.

Reformat those cells as Number with 15 decimal places, and see what is really
there.
--ron