Uploaded April 2024 | Updated November 2026, 4 days ago
How to calculate the value of log in Excel?
Ever wondered how to unlock the power of logarithms in Excel? Today, we're diving deep into this fascinating realm of numbers and formulas. Get ready to embark on a journey that will revolutionize the way you crunch data.
So, grab your spreadsheet and follow the steps as shown in this video.
1. Open your Excel spreadsheet and select the cell where you want to calculate the logarithm.
2. We'll use the LOG function. Here's how it works:
Syntax: =LOG(number, base)
"number" is the value you want to find the logarithm of.
"base" is the base of the logarithm.
3. Input your values into the function. For example:
• =LOG(100, 10) to find the logarithm of 100 to the base 10.
Result: This will give you 2 because 10 raised to the power of 2 equals 100.
• =LOG(8, 2) to find the logarithm of 8 to the base 2.
Result: This will give you 3 because 2 raised to the power of 3 equals 8.
• =LOG(1, 10) to find the logarithm of 1 to the base 10.
Result: This will give you 0 because any number raised to the power of 0 equals 1.
• =LOG(1000, 10) to find the logarithm of 1000 to the base 10.
Result: This will give you 3 because 10 raised to the power of 3 equals 1000.
4. After entering the function, hit enter. Excel will calculate the logarithm for you.
5. Experiment with different numbers and bases to understand how logarithms work in Excel.
6. That's it! You've learned how to calculate logarithms in Excel.
Wasn’t that quick and easy? Thanks for watching!
Please like and subscribe to our channel and
Press the bell icon to get new video updates.
How to calculate the value of log in Excel?
Ever wondered how to unlock the power of logarithms in Excel? Today, we're diving deep into this fascinating realm of numbers and formulas. Get ready to embark on a journey that will revolutionize the way you crunch data.
So, grab your spreadsheet and follow the steps as shown in this video.
1. Open your Excel spreadsheet and select the cell where you want to calculate the logarithm.
2. We'll use the LOG function. Here's how it works:
Syntax: =LOG(number, base)
"number" is the value you want to find the logarithm of.
"base" is the base of the logarithm.
3. Input your values into the function. For example:
• =LOG(100, 10) to find the logarithm of 100 to the base 10.
Result: This will give you 2 because 10 raised to the power of 2 equals 100.
• =LOG(8, 2) to find the logarithm of 8 to the base 2.
Result: This will give you 3 because 2 raised to the power of 3 equals 8.
• =LOG(1, 10) to find the logarithm of 1 to the base 10.
Result: This will give you 0 because any number raised to the power of 0 equals 1.
• =LOG(1000, 10) to find the logarithm of 1000 to the base 10.
Result: This will give you 3 because 10 raised to the power of 3 equals 1000.
4. After entering the function, hit enter. Excel will calculate the logarithm for you.
5. Experiment with different numbers and bases to understand how logarithms work in Excel.
6. That's it! You've learned how to calculate logarithms in Excel.
Wasn’t that quick and easy? Thanks for watching!
Please like and subscribe to our channel and
Press the bell icon to get new video updates.










