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...
If cell A1 contains decimals, then you can also try the function =MROUND(A1,1). This will help to get the nearest round number.
Example: A1 = 3.77
B1 = =MROUND(A1,1)
C1= =B1*B1
Answer = 16.