exponential function

M

Meredith

I need to know if excel can preform this function and if so how do
type it in?
I want it to make column C = 43*e ^-.0054 * column B where e i
the constant e.
If anyone can help I would be very gratefu
 
K

Kieran

Meredith,
try =43*EXP(1)^-0.0054*B5

(change b5 as appropriate)

I do not know what the formula is trying to achieve, but you should b
aware of the order in which excel evaluates the expression a
=43*EXP(1)^-0.0054*B5 is different to =43*EXP(1)^(-0.0054*B5) etc
 
M

Myrna Larson

Hi, Kieran:

Why not EXP(-0.0054)? That giveds the same result.

EXP raises e to the power specified in the parentheses. There's no need to
generate the value of e, then do another exponentiation.
 
Top