ExcelBanter - #num error if negative value.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #num error if negative value. (https://www.excelbanter.com/excel-discussion-misc-queries/3280-num-error-if-negative-value.html)

Dave

#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

All times are GMT +1. The time now is 09:42 AM.