Find value in array
"Kevin Vaughn" wrote...
I know this thread is long closed, but, I THOUGHT that 0^0 would still be 1
(because I thought every value raised to the 0th power was 1,) but when I
tried it in Excel, I got #num (FWIW.)
....
#NUM! is the appropriate result, just as it's the same result as given
by LOG(0). 0^0 is undefined for the very simple reason that if 0^0 =
1, then 0^0 = 0^(n - n) for any n, and so 0^(n - n) = 0^n / 0^n = 0 /
0. But *any* number divided by zero is undefined, *including* zero
itself. All sorts of inconsistencies arise if 0/0 = 0^0 = 1, which is
why it doesn't.
|