Decimal numbers in function not working

ANanfria  wrote:  ``My function allows for me to use a whole number when taking it to a power, yet not a number with a decimal.``

Because when we raise a number to the power of a decimal fraction, we are effectively taking "a root" of the number; for example, 0.5 is the square root.  And usually we cannot take a root of a negative number.

I wonder if the following formula gives you the result that you intended:

=SIGN(D2)*(ABS(D2)/5)^1.534

Caveat:  That will certainly avoid the #NUM error and return a number.  But is it the correct number; or is it GIGO?

If you have doubts, I suggest that you provide the original mathematical equation that led you to want to calculate (D2/5)^1.534 in the first place.

Perhaps we can offer a different perspective on the mathematical solution(s).