answersLogoWhite

0


Best Answer

Excel has no AntiLog function. However, it's just a simple calculation:-

Assuming base 10, the antilog of x is 10^x. 10^x = z is the same as LOG(z) = x

e.g.

LOG10(100) = 2

or

LOG(100,10) = 2

The antilog of 2 is 10^2 = 100

If the 2 was in the cell A5, then the formula could be:

=10^A5

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

8y ago

The POWER function.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the equivalent function to antilog in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is answer of antilog of -4.1?

Both for logs and antilogs, the base must be specified. Once you decide on your base, you can calculate that on any scientific calculator. Use the antilog function (base 10, or base e, if that's what you need), or calculate 10 to the power -4.1 (if you want a base-10 antilog), or e to the power -4.1 (if you want a base-e antilog), or some other base to this power. In Excel, you can use the power operator. For example, for 10 to the power -4.1 (that is, the antilog, base 10), type the following in an Excel cell: =10^-4.1


What is the answer of antilog of 15.59?

Antilog 15.59 is the number whose logarithm is equal to 15.59. If y is the number whose logarithm is 15.59, then log y = 15.59. This is equivalent to y = 10^15.59. So we have: antilog 15.59 = 10^15.59 = 3.89045145E15


Antilog of 6?

Value of AntiLog (6) is 1,000,000.00


How do you get the antilog of a number?

Raise 10 to the power of the number. The antilog of 2 is 102 = 100 The antilog of 5 is 105 = 10,000 The antilog of 'pi' is 103.1416 = 1,385.46 (rounded)


What is the step function of Microsoft Excel?

There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.


How do you calculate an antilog on a casio fx-115ES?

Below the <X-1> key, below the <MODE/SETUP> key, you will find log. You have to press the <SHIFT> key (upper left-most key) and then <log> key (which accesses the <10x> antilog function); then enter the number on which you want to perfom antilog; then press the <Ans> key


A formula prewritten by excel is called?

Function


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


In excel 2013 where are the various function categories stored on the Ribbon?

In Excel Where are the various function categories stored on the Ribbon?


What is the function of percentage in micro-soft Excel?

functions of excel


An If function within an if function in Excel is called what?

A nested if.


How does the trig function ACOS work in Excel?

In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000