Using log and antilog is very common in mathematical calculations. So, users may have to calculate log and antilog in Excel also. To make long, monotonous calculations simple, we have to use the log, and to go back to original values we have to use antilog. Excel has some dedicated Log functions to use but no Antilog functions. Also in mathematics, there is no symbol for the antilog operator. So, in this article, I will give brief explanations of log and antilog and show how to calculate Antilog in Excel.
What Is the Log of a Number?
In brief, it is the power or exponent at which a base value will be raised to be equal to a given number. In an example, we know 103=1000 which means 1000 is equal to the 3rd power of base 10. With logarithm, it will be like, Log10(1000) = 3. Here, 10 is the base value. And, 1000 is the product, and 3 is the power or exponent.
So, it can be said that Log gives the power of a base value to make the number. The format is as follows:
Normal Format: AB=C In Log Format: LogAC=B So, if you ask how many times you have to multiply A to make the value of B then you have to do LogAC or you have to multiply A for B times to make C. this is why we use Log in mathematics. Antilog in mathematics will do the inverse work of log. So, Antilog will give the value of the product of n time multiplication of base a. For an example: Normal Format: LogAB = C In Antilog: AC= B So, antilog is nothing but the power product for the base value. With a Numerical Example: With Antilog : Read More: How to Do Inverse Log in Excel So, you have seen the relationship between the Log and Antilog above. And you understand that to get the value of antilog of a number of any base is nothing but the power equal to the number of the base. And, in Excel, to call the power operator, we have to use the exponent operator (^). For example, 103 will be written in Excel as 10^3. Suppose, here you have some numbers in an Excel file, and you have to calculate the Log values of the numbers and then calculate the Antilog of logs so you will get the number back. Here I will show you how to calculate antilog for base 10, base e, and for any random bases in Excel. In most cases, Log is used for base 10. And in general, where no base value is mentioned, you can assume it as base 10. In Excel, it has an inherent LOG10 function to calculate the log of base 10. But it has no functions to make antilog values. For this, you have to write a manual formula. Follow the steps below: Steps: Read More: How to Calculate Logarithmic Growth in Excel Another most used logarithmic function is log-based e or Ln. When you take the base as exponential operator e, then this becomes Natural Log or Ln. And, in Excel, there is a default function to calculate Ln values, and also antilog values. Which is the LN function. Follow the steps below: Steps: Read More: How to Calculate Natural Logarithm in Excel Sometimes, you have to calculate log and antilog values of numbers for any bases except 10 or e. And to calculate this, in Excel, you will find the LOG function. But to calculate the antilog value, you have to write a manual formula. Follow the steps below: Steps: Read More: How to Calculate Log Base 2 in Excel Download Practice Workbook You can download the practice workbook from here: In this article, I have shown how to calculate antilog in Excel. Also, you have found the relation between the log and the antilog in mathematics. Download the free workbook and practice yourself. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.Relation between Log and Antilog
How to Calculate Antilog in Excel: 3 Types
Type 1: Calculate Antilog for Base 10
=LOG10(B4)
=10^C4
Criteria 2: Calculate Antilog for Base ‘e’
=LN(B4)
=EXP(C4)
Criteria 3: Calculate Antilog for a Random Base
=LOG(B4,5)
=5^C4
Conclusion
Related Articles
