can I calculate 12 to the 360th power

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get the following formula to work. I continue to get the #NUM
error. It appears that Excel cannot calculate powers as high as 360. Does
anybody know any type of workaround or a way to re-write this formula with
the same results???

=((15*B32*(((D30+12)^360)-(3.2007265854675*(10^388))))/(D29*(((D30+12)^360)-3.2007265854675*(10^388))+(0.25*D30*((D30+12)^360))))

I REALLY appreciate your response!!!!!!!!!!!!
 
I don't wish to be too impolite, but your formula looks a bit of a mess and
is therefore hard to follow, and perhaps debug - you could try breaking it
accross more than one cell and maybe simplifying your algebra so that such
high powers are not needed. To come back to your question, what you say is
not true. It is only true when the result is above the range that Excel
f.p. numbers support. Try using logs and some basic mathematical
identities. That it so say, take logs of the thing you are trying to raise
to the nth power, multiply by n and then take the exponent of the result.
Remember that e^709 is supported in Excel but e^710 is not.

Steve Dalton
 
If I have followed the formula correctly the result should = a value
greater than e^710 (most handheld calculators support negative
numbers as well as square roots but not the correct polar/rectangular
result of the square root of a negative number hence an error result)
The same message appears to be the result of your formula
 
Back
Top