ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Mathmatical functions in Excel (https://www.excelbanter.com/excel-worksheet-functions/193041-mathmatical-functions-excel.html)

MAC JUNIOR

Mathmatical functions in Excel
 
How do you find the Antilogarithm of a number

Ken Johnson

Mathmatical functions in Excel
 
On Jun 30, 12:50 am, MAC JUNIOR <MAC
wrote:
How do you find the Antilogarithm of a number


For base e use EXP(number). For base 10 use 10^number.

Ken Johnson

Rick Rothstein \(MVP - VB\)[_785_]

Mathmatical functions in Excel
 
Either use...

=10^Number

for Log Base 10 or use...

=EXP(Number)

for Natural Logs.

Rick


"MAC JUNIOR" <MAC wrote in message
...
How do you find the Antilogarithm of a number



ShaneDevenshire

Mathmatical functions in Excel
 
Hi,

if cell B1 contains:
=LOG(A1)
Then
=10^B1

--
Cheers,
Shane Devenshire


"MAC JUNIOR" wrote:

How do you find the Antilogarithm of a number


omnitechsupport

Mathmatical functions in Excel
 

You can just use the formula

=log(A1)to get the logarithm of any number.


All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com