get logarithms of value in Excel

Q77. Is there a way to get a log value of a number using 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.

excel get logarithms of value

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.

excel excel get logarithms of value

 

You can find similar Excel Questions and Answer hereunder

1) Filtering the value field in a pivot table in Excel

2) How can I loop through all WorkSheets and get their names using VBA?

3) How do I find the median salary of employees with the same skillset in my Organization?

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

5) Vlookup to return max value from multiple hits in Excel

6) I conducted a test and the test scores are available - how can I get Percentile rank of students?

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

8) I am considering an investment of $500 per month for 3 years @ 6% interest rate. What is the Present Value of investment?

9) 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?

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

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

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

13) Is there a way I can easily identify the duplicate values in a dataset?

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

15) How can I get row count of filtered data?