View Single Post
  #1   Report Post  
Dave
 
Posts: n/a
Default #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