#num error if negative value.
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
|