To derive the antilog of a number in Excel, we use the following steps:

1. We take the number whose antilog we want to find.
2. We then take its logarithm using the LOG() function.
3. We then use the EXP() function to calculate the antilog.

Example:

Find the antilog of 2.5 in Excel.

Solution:

:2.5



2. The logarithm of 2.5 can be calculated using the LOG()


3. function as follows:

3. 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.

4. Therefore, the antilog of 2.5 is 1.97403068780791.