Excel/ Google Spreadsheet help...

[SeaPanda]

What's up guys,

I need help with setting up a function that takes inputs from each serrate row in column A and takes the natural log of each separate row... also what would the function be to multiple the natural log by a input. I haven't used spreadsheet in ages so sorry for the noob question.

[Vitalius]

What's up guys,

I need help with setting up a function that takes inputs from each serrate row in column A and takes the natural log of each separate row... also what would the function be to multiple the natural log by a input. I haven't used spreadsheet in ages so sorry for the noob question.

... so...

In the formula field (say, for B1), input the following:

=LN($A1)

That would give you the natural log of the value in A1. Then drag it down to get other values in each row.

Say, in C1, you put:

=$B$1*$D$1

Where D1 is where your input would be. You'd have to obviously drag that down for each row as well to get each natural log for each row multiplied by the input.

An inelegant way, but one that would work.

 

The Natural Log function in MS Office: https://support.office.com/en-us/article/LN-function-81fe1ed7-dac9-4acd-ba1d-07a142c6118f

[SeaPanda]

... so...

In the formula field (say, for B1), input the following:

=LN($A1)

That would give you the natural log of the value in A1. Then drag it down to get other values in each row.

Say, in C1, you put:

=$B$1*$D$1

Where D1 is where your input would be. You'd have to obviously drag that down for each row as well to get each natural log for each row multiplied by the input.

An inelegant way, but one that would work.

 

The Natural Log function in MS Office: https://support.office.com/en-us/article/LN-function-81fe1ed7-dac9-4acd-ba1d-07a142c6118f

Thanks for the help I appreciate it