log 'e' function problem

  • Thread starter Thread starter Paul Robinson
  • Start date Start date
P

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?
 
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?
Click to expand...

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

--ron
 
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


Dana DeLouis said:
Not sure, but

=1.71*EXP(0.14*8)

returns 5.24

HTH
Dana DeLouis


Paul Robinson said:
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?
Click to expand...
Click to expand...
 
Back
Top