Pie in Excel??

[JaredMcCullough]

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

 

[JaredMcCullough]

I am having trouble with this format essential i have cell B2 and C2 I need

B2 to be the formula and B3 to be the answer to the formula I have been

using a UDF which allows me to have mutiple numbers as text in the

formual cell then in the corresponding cell beside i type =math() of the

cell. I have a formula set with =PI()*7 in cell B2 and i was going to have

the answer in cell C2 using =math(B2) but if i leave B2 as generic text it

converts the formula in that cell and if i change it to text then cell C2 i

dont think is reading the formula for Pi thus creating an error??? Does

anyone know how to get what i am trying to accomplish

 

[mikerickson]

If the Formula =PI()*7 is in B2, what do you want C2 to show, what do you want B3 to show?
If maths is a UDF, what is the code for that UDF?

 

[JaredMcCullough]

sorry i realize why that was confusing ok here is what i have so far the UDF which is set is

Function Maths(MyVal As String) As Double<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o></PRE> Maths = Evaluate("=" & MyVal)<o></o>
End Function<o></o>


ok i have this equation 378*(PI r squared) which occurs multiple times

throughout my spreadsheet essentially for cell B2 its 378*(PI*7^2) thats

information so what i was trying was in B2 i put =PI()*7^2*378 the

reason i want the formula in this cell and not just the answer is so that

the values can be changed and the reflected answer which i was trying to

make in B3 would adjust automatically so what i did was put in B3 was

=maths(B2) but it didnt work just wondering if anyone new what was

wrong or had another way of going about it

 

[mikerickson]

It sounds like you want the string 378*(PI()^7^2) in B2 and =Maths(B2) in C2.
But that is going three ways around the barn.

so that the values can be changed and the reflected answer ... in B3

Putting 378 in B1, 7 in B2 and =B1*(PI()*B2^2) in B3, allowing you to change the values in B1 and B2 and see the result in B3, is the more direct way.

 

[JaredMcCullough]

The problem is i only have created the rest of the spreadsheet to format with cell B being the formula cell and cell C being the answer to it all my formulas are strings written in cell B with the answer in C and this is my last formula due to the fact i could not figure out how to get it so essentially to fit in with the rest of the spreadsheet i need the formula in cell B and the answer in cell C if that is plausable if not i will make do some other way

 

[JaredMcCullough]

Oh sorry i did not see the string you created it worked perfectly thank you very much i appreciate all your help