Excel Made Easy

Get logarithms of value in Excel

To do it in Excel, here is the answer:

a) Enter the formula =LOG10(number), where number is the value for which log value is to be determined.

b) In case natural logarithm of number is required (as opposed to base 10), enter the formula =LN(number), where number is the value for which log value is to be determined.

You can find similar Excel Questions and Answer hereunder

1) How to read a value from a cell in vba in Excel

2) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?

3) Given a raw data Table, how can I find the value of a field for a specific value of another field?

4) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

5) How can I get the last non-zero value in a row?

6) How can I get the information about my current operating environment (OS version, Excel version, Current Directory)

7) How can I filter a table to get all records that have less than a particular value in a specific column?

8) How can I prevent users from entering duplicate values in a range?

9) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

10) How can I find the slab in which a given value fits?