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 Hi Prashant,
Pi is certainly a constant in Excel, and e can be obtained using EXP(1). Users can define their own functions, constants included. The usefulness depends on the frequency of use of the constant, but it's a nice feature to have.
I welcome your questions on algebra, 2D and 3D geometry, parabolic functions and conic sections, and any other mathematical queries you may have.
4 years as a drop-in and by-appointment tutor at Champlain College.
Private tutor for dozens of clients over the past 8 years.
Publications CALPHAD: Computer Coupling of Phase Diagrams and Thermochemistry
Education/Credentials Bachelor of Science, Major Mathematics and Major Economics, McGill University, 2014.
Diploma of Collegiate Studies; Pure and Applied Science, Champlain College Saint-Lambert, 2010.