If not, how can I figure it out?
I wish to write a figure in one cell and recieve its antilog in other cell.
2006-09-11 03:37:07 · 9 answers · asked by Elad 2 in Science & Mathematics ➔ Mathematics
Yes, 10^y = z is the same as log(z) = y.
2006-09-11 03:39:49 · answer #1 · answered by AlphaOne_ 5 · 5⤊ 1⤋
Inverse Log Function
2016-11-02 11:34:19 · answer #2 · answered by Anonymous · 0⤊ 0⤋
1
2017-01-20 09:40:50 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Natural log or common log.
For the inverse of the common log, it's 10^n, where n is the log of the number.
For the inverse of the natural log, it's exp(n), where n is the ln of the number.
Edit: Technically, the power function could also be used, but it doesn't seem to add much value. Also, Excel has a very good help section (in this case, looking for the inverse wouldn't help much, since it seems to be assumed that a person using logarithms in a spread sheet knows how to find the inverse already)
2006-09-11 03:43:26 · answer #4 · answered by Bob G 6 · 5⤊ 0⤋
This Site Might Help You.
RE:
Is there an anti-log (inverse-log) function in Excel?
If not, how can I figure it out?
I wish to write a figure in one cell and recieve its antilog in other cell.
2015-08-13 09:02:56 · answer #5 · answered by Anonymous · 0⤊ 0⤋
Antilog In Excel
2016-12-17 13:48:34 · answer #6 · answered by lineback 4 · 0⤊ 0⤋
There is, for probability functions. But otherwise it doesn't make sense to do.
EXP() is the opposite of ln
POWER() is the opposite of LOG
2006-09-11 03:43:34 · answer #7 · answered by J G 4 · 4⤊ 0⤋
The opposite of log is the exponential; for example, the opposite of log2 X is 2^X.
2006-09-11 03:41:30 · answer #8 · answered by bruinfan 7 · 1⤊ 0⤋
How to work out for example beta= b In10
2016-09-07 03:15:03 · answer #9 · answered by ? 1 · 0⤊ 0⤋
LN() takes the log
EXP() takes the antilog for natural logarithms
In Base 10
LOG() takes the log
ANTILOG() takes the antilog.
2006-09-11 04:02:43 · answer #10 · answered by Anonymous · 4⤊ 5⤋