B
Barry
Can anyone show me how to write a formula to square a value in another cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
=POWER(A1,2)
=A1*A1
=A1^2
HTH
=A1*A1
=A1^2
HTH
D
Dave F
=A1^2
=2^2 etc.
The ^ symbol indicates exponentiation. If you're raising to a fractional
power (or taking a root other than the square root, parentheses are
important; i.e., =A1^(1/3) etc.
Dave
=2^2 etc.
The ^ symbol indicates exponentiation. If you're raising to a fractional
power (or taking a root other than the square root, parentheses are
important; i.e., =A1^(1/3) etc.
Dave
B
Bill Kuunders
=power(A16,2)
B
Barry
Sorry, but I found it by clicking on the drop-down list of functions to the
left of the fx enter window and searching for "square a value", which
returned the 'POWER' function, which is =POWER(Number, Power)
left of the fx enter window and searching for "square a value", which
returned the 'POWER' function, which is =POWER(Number, Power)