This proves that our formula was able to correctly find the inverse of logs of these values. Notice from the above image that the results in column C are equivalent to the original values in column A. You should now have the antilogs of all values of column B in column C. Copy this formula to the rest of the cells of column C by dragging down the fill handle.This will display the antilog of the value B2 in cell C2.Select the first cell where you want the result to be displayed.Let us see the steps to find the antilogs of the values in column B: Let us say you have the following list of values (column A) and their logs (column B). Keeping the above mathematical relationship in mind, finding the antilog of a number base-10 in Excel simply means finding the value of 10 raised to the power of that number.įor this, we use the exponent operator (‘^’). Then antilog of ‘a’ would be: x = 10 a How to Calculate Antilog in Excel So the base-10 antilog of this number would be 10 0.69897 = 5 So, to find the antilog of a number, all you need to do is raise it to the power of 10.įor example, the base-10 log of the number 5 is 0.69897. In other words, it is the inverse of the LOG10 function (or Log function if using a base other than 10). The antilog of a number, in Excel, is the inverse of the log of a number (to the base 10). 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?.

Natural log in excel