Guest bkronbergs Posted July 6, 2004 Share 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! Link to comment Share on other sites More sharing options...
JaKiri Posted July 6, 2004 Share 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) Link to comment Share on other sites More sharing options...
mossoi Posted July 6, 2004 Share Posted July 6, 2004 I may be off the mark but can't you just use: =22/7 Link to comment Share on other sites More sharing options...
Radical Edward Posted July 6, 2004 Share 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 Link to comment Share on other sites More sharing options...
mossoi Posted July 6, 2004 Share Posted July 6, 2004 Fair enough. I thought it wouldn't be that simple. =pi() gives the value to 9 dp's. Link to comment Share on other sites More sharing options...
MandrakeRoot Posted July 6, 2004 Share 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 Link to comment Share on other sites More sharing options...
Dave Posted July 6, 2004 Share 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. Link to comment Share on other sites More sharing options...
DeoxyriboNucleicAcid Posted July 6, 2004 Share Posted July 6, 2004 I think this will be all you need: pi is exactly 3 Link to comment Share on other sites More sharing options...
Sayonara Posted July 6, 2004 Share Posted July 6, 2004 RTFQ Link to comment Share on other sites More sharing options...
Cap'n Refsmmat Posted July 6, 2004 Share Posted July 6, 2004 Oooh! A new acronym! Link to comment Share on other sites More sharing options...
mossoi Posted July 6, 2004 Share 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. Link to comment Share on other sites More sharing options...
Sayonara Posted July 6, 2004 Share Posted July 6, 2004 Oooh! A new acronym! DAMN! I could have used the acronym tag for comedy effect. It's hardly new. Link to comment Share on other sites More sharing options...
Cap'n Refsmmat Posted July 6, 2004 Share 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 Link to comment Share on other sites More sharing options...
Sayonara Posted July 6, 2004 Share Posted July 6, 2004 So? Things don't just start existing when you first encounter them. Stop spamming. Link to comment Share on other sites More sharing options...
Sayonara Posted July 6, 2004 Share 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] Link to comment Share on other sites More sharing options...
Dave Posted July 6, 2004 Share Posted July 6, 2004 Read the Fudging Question Nah. Read the fine question Link to comment Share on other sites More sharing options...
bloodhound Posted July 6, 2004 Share Posted July 6, 2004 na. i think its [hide] Rock The Filtering Queen [/hide] Link to comment Share on other sites More sharing options...
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