Pie in Excel??

[JaredMcCullough]

I was wondering if there is something that represents the numerical number of pie within excel

 

[Jonmo1]

There is a function called PI

=PI()

 

[VoG]

Assuming that you mean pi try

=PI()

 

[JaredMcCullough]

thanks and lol sorry ya i wasnt thinking trying to get work done fast when using this function do you put what your doing with it inside the parenthesis or how does it work

 

[mikerickson]

In VBA you can use 4 * Atn(1) or Application.WorksheetFunction.Pi()

 

[VoG]

Random example

=PI()*37

 

[JaredMcCullough]

What about squaring a number

 

[tc88]

What about squaring a number

Such as PI?

=PI()^2

 

[VoG]

=A1^2

With diameter in A1, area of circle

=PI()*(A1/2)^2

 

[JaredMcCullough]

ok say i have the radius .031 the formula should be

=PI()*(.031^2) and then in the next cell i have =maths() of the cell that

the formula is in