You are here:

Calculus/Mathematical constants in Excel.

Advertisement


Question
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

Answer
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

Calculus

All Answers


Answers by Expert:


Ask Experts

Volunteer


Abe Mantell

Expertise

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!

Experience

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

©2016 About.com. All rights reserved.