![]() ![]() ![]() For example, =LOG(81,3) would give you 3 (where 3×4 is 81) What is the Relationship between Log and Antilog? So if you type: =LOG10(1000) in a given cell, you should get the result as 3.Īnd if you want to specify the base yourself as well, you can use the LOG function. In Excel, we use the LOG10 function to find the log of a number to the base 10. Similarly, we could express 100,000 with the number 6, which is a single digit too! Imagine how easy it then gets to express really large numbers. Logarithms, therefore, are usually used to express really large numbers in fewer digits.įor example, in the above case, we expressed the number 1000 in just a single-digit number, 3. That means the log to the base 10 of 1000 is 3! This can also be symbolically expressed as: Log 10(1000) = 3 Since you need to multiply it 3 times to get 1000, i.e: 10 x 10 x 10 = 1000 So, if you want to know what is the log of the number 1000 to the base 10, you are actually finding out how many times the number 10 needs to be multiplied to get 1000. The factor that is getting repeatedly multiplied is known as the base of the logarithm. In simple words, the log of a number is the number of times a factor occurs in the number in repeated multiplication. How to Calculate Antilog of a Natural Logarithm in Excel.What is the Relationship between Log and Antilog?.What does the Log of a Number Tell You?. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |