Is it possible to enter exponentials in a cell(Excel 97)?
For example, 5271*D*exp-1.9593 (D can be a figure in another cell). I am somewhat rusty in VBA but will be coming up to speed soon. Thank you.
Thank you for your response. Didn't I tell you I was rusty? With all this concern over NFPA 70E - Arc Fault Protection I needed to quickly calculate the incident energy of an arc in open air. So rather than an exponential function I had intended to seek help on writing an excel equation for an expression that had a number raised to a power. Never-the-less, I did come up with an expression as shown below. It represents the equation found in NFPA 70E, B-5.1 for an Arc in Open Air with result in cal/cm-sqd.
That is not the same thing. The EXP function is e (2.71828) raised to the nth power. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.