Home |
Search |
Today's Posts |
#24
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display an array of references | Excel Worksheet Functions | |||
how to find all matches in an array | Excel Discussion (Misc queries) | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |