MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Area of a Circle

Posted by Rich on August 13, 2001 1:44 PM

I know the formula is pi*radius sqared but I can't find a way to easily square the number. What I want to do is have one column for the size of the circle then the area formula * 14.7 for air pressure against vacuum.

Thanks, Rich Benn

Posted by Aladin Akyurek on August 13, 2001 1:46 PM

=A1^2 squares the number in A1 (or just: =A1*A1). (NT)

Posted by faster on August 13, 2001 1:47 PM

to square a number use ^

as in 4^2 = 16