Goal: Calculate the area of a square or cube.
POWER multiplies a number by itself. SQRT finds the root side of a square.
Ready...
Ready...
💻 Formula Structure
=POWER(number, power)
- 1. Number: The base number (e.g., 4).
- 2. Power: The exponent (e.g., 2 for squared).
- Alt: You can also use the caret symbol:
=A1^2
=SQRT(number)
- 1. Number: The value to find the root of (e.g., 25).
- Note: Equivalent to
=POWER(25, 0.5).
-- Select a calculation...
...
⚠️ Common Pitfalls
🚫 Negative Roots
You cannot find the Square Root of a negative number (e.g., SQRT(-4)). Excel returns a #NUM! error.
🎹 Caret Operator (^)
Using =A1^2 is faster to type than =POWER(A1, 2), but the function is more readable in complex formulas.