Two Excel Questions please Help?

Question

Okay I have two questions for excel:
1. I want to multiply a natural log(LN) by 3, for example : 3ln(5) and the excel doesn't seem to recognize it. How can I do it?
2. Can I make the excel give an answer with variables? For example(this is connected to my previous question) : give the excel a equation like this - (3ln(X))^2 - will excel be able to operate this?

Thanks!

Answer 1

1) 3*LN(5)



2) No. Excel can't do algebra, you could replace x with the value in another cell and then increment both. ( 3*LN(A1) )^2 etc.

Answer 2

2 short answer - no. you will need to get some software to do the symbolic operations to aid excel's math operations. MATLAB has a symbolic solver that could do it, also.



#1 when i put the argument:

=3*LN(5)

the cell becomes

4.828313737

Answer 3

1) =ln(5)*3 should work



2) =(ln(Cell_Name)*3)^2

can be used to operate on any cell, which you imput as your variable