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
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
To find the antilogarithm (antilog) on a Casio fx-115ES calculator, you can use the exponentiation function. First, enter the value for which you want to find the antilog. Then, press the "SHIFT" key followed by the "10^x" button. This will calculate (10) raised to the power of your entered value, giving you the antilog.
The antilog of a number is the inverse operation of taking the logarithm of that number. In this case, the antilog of 0.176 can be found by raising 10 to the power of 0.176. This is equivalent to 10^0.176, which is approximately equal to 1.495. So, the antilog of 0.176 is approximately 1.495.
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
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.
Roughly 95,499,258.6
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)
Function
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 Where are the various function categories stored on the Ribbon?
functions of excel
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