fskilnik
asked on
Cell with dynamic formula
Hi there!
If the cell A1 has the number 0.2 in it, and cell A2 has the number 0.3 in it, then if I type =LN(A1/A2) in cell A3, I will get the natural logarithm of the ratio A1 to A2 , of course.
Suppose I want to have something dynamic, say the possibility of changing the digit 2 in the =LN(A1/A2) formula, to another positive integer, to be obtained using some formula.
In other words, I want to calculate =LN(A1/A someformulathatgives2)
I thought about changing the cell to that: = LN(A1/"A"&2) so that I am able to put a formula in the place of 2... it gives an error.
How this should be done, please?
Thanks,
fskilnik.
If the cell A1 has the number 0.2 in it, and cell A2 has the number 0.3 in it, then if I type =LN(A1/A2) in cell A3, I will get the natural logarithm of the ratio A1 to A2 , of course.
Suppose I want to have something dynamic, say the possibility of changing the digit 2 in the =LN(A1/A2) formula, to another positive integer, to be obtained using some formula.
In other words, I want to calculate =LN(A1/A someformulathatgives2)
I thought about changing the cell to that: = LN(A1/"A"&2) so that I am able to put a formula in the place of 2... it gives an error.
How this should be done, please?
Thanks,
fskilnik.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome fskilnk! Glad it worked as desired. :)
Thanks for the feedback.
Regards.
Neeraj
Thanks for the feedback.
Regards.
Neeraj
ASKER
Thank you, Neeraj!
ASKER
Thank you for the solution. It worked perfectly.
Regards,
fskilnik.