Tips.Net > ExcelTips Home > Worksheet Functions > Math and Trig Functions > Deriving Antilogs
Deriving Antilogs
Summary: Antilogs are not one of the trigonometric functions that are built into Excel. You can easily calculate these values by creatively using some of the other worksheet functions available. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
Excel allows you to use quite a few different trigonometric functions in your worksheets. If you are big into trig, you may wonder why there are no functions that derive antilogs.
An antilog in Excel is technically defined as the inverse of the LOG10 function. The LOG10 function means the logarithm in base 10 of a number. Given that definition, the antilog, or inverse log, of any number is simply 10 raised to that number. For instance, the base-10 log of 4 is 0.60206, and the base-10 antilog of 4 is 10,000 (10 raised to the fourth power). This also means that the base-10 antilog of the base-10 log of 4 is, again, 4. (Raising 10 to the 0.60206 power is 4.)
The following table shows how you would derive the antilogs of the different log functions within Excel.
| Base | Number | Log | Antilog (Power) | |||
|---|---|---|---|---|---|---|
| x | y | =LOG(x,y) | =x^y | |||
| e | y | =LN(y) | =e^y | |||
| 10 | y | =LOG10(y) | =10^y |
Tip #2171 applies to Microsoft Excel versions: 97 2000 2002 2003
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.
Check out ExcelTips: Filters and Filtering today!
Perplexed by Pivots?
PivotTables don't need to be scary or mysterious. Use this powerful tool to analyze your data in ways you didn't know were possible. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site