#num error if negative value.

D

Dave

I have the following formula that gives me a #num error
when one of my cell reference is negative?

Any ideas how to the value without making the result or
the cell reference positive?

=IF(ISBLANK(M25),"",(Q25/M25)^(1/4)-1)
m25 q25
1.14 -0.73


Thanks a million! Really need this!

Dave
 
J

JE McGimpsey

One way:

=IF(M25="","",IF(Q25/M25>=0,(Q25/M25)^(1/4)-1,"-1+" & ABS(Q25/M25)^(1/4)
& "i^(1/2)"))
 
Top