log 'e' function problem

[Paul Robinson]

I want to create a chart that plots values which are calculated by a formula
which incorporates log e. How do I type this function into a cell?
My formula is : P log e xt

P = 1.71, x = 0.14 and t = [year number].

Thus for year 8 I have a value of 5.24.

I worked the value out on my calculator but wish to enter this formula onto
the spreadsheet for automatic calculation. Can anyone tell me how I can do
this, please?

 

[Ron Rosenfeld]

I want to create a chart that plots values which are calculated by a formula
which incorporates log e. How do I type this function into a cell?
My formula is : P log e xt

P = 1.71, x = 0.14 and t = [year number].

Thus for year 8 I have a value of 5.24.

I worked the value out on my calculator but wish to enter this formula onto
the spreadsheet for automatic calculation. Can anyone tell me how I can do
this, please?

When you enter this into your calculator, what operators do you use between
each factor?

--ron

 

[Dana DeLouis]

Not sure, but

=1.71*EXP(0.14*8)

returns 5.24

HTH
Dana DeLouis

 

[Dana DeLouis]

I worked the value out on my calculator but ...

Another explanation might be that on some Calculators, E^x, and Ln(x) are on
the same key. You may have to press a shift key on your calculator to get
the "other" function. Not sure, but this may explain any discrepancies.

My guess for the op is
=1.71*LN(0.14*8)

based on:
P log e xt

Dana DeLouis

Not sure, but

=1.71*EXP(0.14*8)

returns 5.24

HTH
Dana DeLouis

I want to create a chart that plots values which are calculated by a formula
which incorporates log e. How do I type this function into a cell?
My formula is : P log e xt

P = 1.71, x = 0.14 and t = [year number].

Thus for year 8 I have a value of 5.24.

I worked the value out on my calculator but wish to enter this formula onto
the spreadsheet for automatic calculation. Can anyone tell me how I can do
this, please?