Could someone please tell me how to calculate pi in the windows program excel please? If you could post the solution under this thread, or just email it, I would be very grateful. THANKS!

I can't remember if the BASIC style programming in Excel allows x=x+1 style arrangements, but if it does, use pi/4=1 - 1/3 + 1/5 - 1/7 + 1/9 - . . .

 

(in basic this would be along the lines of

 

10 FOR N = 1 TO 100

20 LET Q = 1/(2N-1)

30 LET P = P + Q

40 NEXT N

50 LET P = P*4

60 PRINT P)

I may be off the mark but can't you just use:

 

=22/7

I may be off the mark but can't you just use:

 

=22/7

 

no. pi is irrational. 22/7 is only a very rough approximation. (2dp)

 

http://www.google.com/search?hl=en&lr=&ie=UTF-8&q=22%2F7+-+pi

Fair enough. I thought it wouldn't be that simple.

 

=pi() gives the value to 9 dp's.

How about using a cell and writing

=ACOS(-1),

that gives you PI also, until whatever decimal precision that excel uses, probably enough for your calculations

 

Mandrake

It should be noted that excel will only go to a certain number of decimal places anyway, so there's not much point.

I think this will be all you need:

pi is exactly 3

 

RTFQ

Oooh! A new acronym!

Read the Fudging Question I reckon.

 

IE - when someone posts asking HOW to calculate Pi in Excel then Pi to 10,000 dp's isn't a very useful response.

Oooh! A new acronym!

DAMN! I could have used the acronym tag for comedy effect.

 

It's hardly new.

First time I've seen it.

 

In other words, I think it's new, not I KNOW it's just been made up

So? Things don't just start existing when you first encounter them.

 

Stop spamming.

By the way, "today" as an attribute of the INS tag will be wrong by tomorrow.

 

[acr=Reply Not Required]RNR[/acr]

Read the Fudging Question

 

Nah.

 

Read the fine question

na. i think its

 

[hide]

Rock The Filtering Queen

[/hide]