×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Exponentials

Exponentials

Exponentials

(OP)
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.

RE: Exponentials

Use the EXP function. Just search for exp in the help and you will see the format required. For your case, where D1 is the value in cell D1:

= 5271*D1*EXP(-1.9593)

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Exponentials

(OP)
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.

=5271*(POWER(C2,-1.9593))*C3*((0.0016*C4*C4)-(0.0076*C4)+0.8938)

Thank you, again.

RE: Exponentials

you can use:

=5271*C2^(-1.9593)* .....

RE: Exponentials

energetika:

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources