Forum Discussion
Simple Excel question
Writing some formulas, and when trying to square whole numbers (ex 4x4), Excel provides wrong answer (14.21). I have tried as (A1)^2, (A1) x (A1) and both come back with the wrong answer (14.21). A...
Format A1 as General, or as Number with 4 decimal places.
Do you see 4 or something like 3.7696?
I tried your examples and Excel gave me an error and converted =(A1)x(A1) to =(A1)*(A1) Where A1 was General format and contained the number 4. The function answer was 16 and was also General format. Using the number format you can set the number of decimal points to 0 for whole numbers.
Cheers,
Clark