You are here:

- Home
- Teens
- Homework/Study Tips
- Calculus
- Mathematical constants in Excel.

Advertisement

Dear Prof Abe

http://en.wikipedia.org/wiki/Microsoft_Excel

http://en.wikipedia.org/wiki/Mathematical_constant

http://www.ebyte.it/library/educards/constants/MathConstants.html

http://pi.lacim.uqam.ca/eng/table_en.html

http://reference.wolfram.com/mathematica/tutorial/MathematicalConstants.html

http://books.google.co.in/books?id=TWiUKWP-ACIC&pg=PA5&lpg=PA5&dq=mathematical+c

1. Is it possible to input mathematical constants in cell/s using

functions in Excel ?.

For example : PI, e, Pythagoras constant, Omega Constant, Ramanujan - Soldner constant, Golden Ratio, Legendre's constant etc ?.

2. Will it be useful to create functions for inputting mathematical constants in excel spreadsheets (if not available) ?.

Thanks & Regards,

Prashant S Akerkar

Hello Prashant,

1. Yes, just enter the function in the desired cell...then refer to that cell each time

. you want the constant.

2. Not sure what you mean by "create functions for inputting" the constants...

. Do you mean functions that generate the constants, rather than typing them in manually?

Abe

- Add to this Answer
- Ask a Question

Rating(1-10) | Knowledgeability = 10 | Clarity of Response = 10 | Politeness = 10 |

Comment | Dear Prof Abe Thank you. Thanks & Regards, Prashant S Akerkar |

Calculus

Answers by Expert:

Hello, I am a college professor of mathematics and regularly teach all levels from elementary mathematics through differential equations, and would be happy to assist anyone with such questions!

Over 15 years teaching at the college level.**Organizations**

NCTM, NYSMATYC, AMATYC, MAA, NYSUT, AFT.**Education/Credentials**

B.S. in Mathematics from Rensselaer Polytechnic Institute

M.S. (and A.B.D.) in Applied Mathematics from SUNY @ Stony Brook