Guest bkronbergs Posted July 6, 2004 Posted July 6, 2004 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!
JaKiri Posted July 6, 2004 Posted July 6, 2004 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)
Radical Edward Posted July 6, 2004 Posted July 6, 2004 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
mossoi Posted July 6, 2004 Posted July 6, 2004 Fair enough. I thought it wouldn't be that simple. =pi() gives the value to 9 dp's.
MandrakeRoot Posted July 6, 2004 Posted July 6, 2004 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
Dave Posted July 6, 2004 Posted July 6, 2004 It should be noted that excel will only go to a certain number of decimal places anyway, so there's not much point.
DeoxyriboNucleicAcid Posted July 6, 2004 Posted July 6, 2004 I think this will be all you need: pi is exactly 3
mossoi Posted July 6, 2004 Posted July 6, 2004 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.
Sayonara Posted July 6, 2004 Posted July 6, 2004 Oooh! A new acronym! DAMN! I could have used the acronym tag for comedy effect. It's hardly new.
Cap'n Refsmmat Posted July 6, 2004 Posted July 6, 2004 First time I've seen it. In other words, I think it's new, not I KNOW it's just been made up
Sayonara Posted July 6, 2004 Posted July 6, 2004 So? Things don't just start existing when you first encounter them. Stop spamming.
Sayonara Posted July 6, 2004 Posted July 6, 2004 By the way, "today" as an attribute of the INS tag will be wrong by tomorrow. [acr=Reply Not Required]RNR[/acr]
bloodhound Posted July 6, 2004 Posted July 6, 2004 na. i think its [hide] Rock The Filtering Queen [/hide]
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now