To derive the antilog of a number in Excel, we use the following steps:
- We take the number whose antilog we want to find.
- We then take its logarithm using the
LOG()
function.
- We then use the
EXP()
function to calculate the antilog.
Example:
Find the antilog of 2.5 in Excel.
Solution:
:2.5
- The logarithm of 2.5 can be calculated using the
LOG()
- function as follows:
(0.405465108108164) ; LOG(2.5) = 0.405465108108164.
- Now that we have the logarithm of 2.5, we can calculate its antilog using the
EXP()
function as follows:
(1.97403068780791) ; EXP(0.405465108108164) = 1.97403068780791.
- Therefore, the antilog of 2.5 is 1.97403068780791.