exponential function

[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

 

[Myrna Larson]

The function you want is EXP.

EXP(-.0054) = 0.994615

=43*EXP(-.0054)*B1

 

[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

 

[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.