# How to calculate the antilog (inverse log) in Excel

Raise 10 to the log value with `=10^A2`, or use `=EXP(A2)` for a natural log.

**Excel:** `=10^A2` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B |
| --- | --- |
| Log value | Antilog |
| 2 |  |
| 0.5 |  |
| -1.3 |  |
| 3.25 |  |
| 0 |  |

Formula in B2, filled to B6: `=10^A2`

Result: 100; 3.16227766; 0.05011872336; 1778.27941; 1

## How it works

The antilog reverses LOG10: if LOG10(100) is 2, then 10² is 100. Fractional and negative logs work the same way: 10^0.5 is about 3.162 and 10^-1.3 is about 0.0501. The log of 1 is 0, so the antilog of 0 is 1.

## Other ways

- `=POWER(10,A2)`: The function form of the same calculation.

## Common mistakes

- Use the same base you took the log with. Values from LN need EXP, not 10^.
- Large logs overflow: 10^309 returns #NUM! because it is beyond the largest number Excel can store.

## Questions

**How do I get the antilog of a natural log?**

Use `=EXP(A2)`.

**How do I get the antilog in base 2?**

Use `=2^A2`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/calculate-antilog