I am using Excel to get some hairy calculations done (a significance test on a trinomial distribution, ugly!) and I just noticed that when I enter a formula like
=D47^0, I get a
#NUMBER error, when math textbooks insist that I should get a 1.
Is this a bug and if yes, how come nobody noticed it before?! Am I doing something wrong? Is there a workaround other than use a IF formula which checks for a zero in the exponent?
I already tried using the "normal" POWER(number;exponent) formula instead of the shortcut circumflex, without success.