Help Needed for The Formula Using IFERROR, IF, MIN, ect.

[dager6]

Hi,

I got an error message when I try to fix a problem I had.

Sometimes the MIN could be negative, which mess up the values MAX - MIN. I tried to add the IF to fix it, but somehow it did not work.

And the one I had is pasted below.

 ActiveCell.FormulaR1C1 = _
        "=iferror(1/(MAX(RC[-" & PWYears + 4 & "]:RC[-5])-if(MIN(RC[-" & PWYears + 4 & "]:RC[-5])>0,MIN(RC[-" & PWYears + 4 & "]:RC[-5]),-MIN(RC[-" & PWYears + 4 & "]:RC[-5])))/AVERAGE(R4C2:R" & IHeight & "C" & PWYears + 1 & ")*10,100000)" 

Thanks,

Matt

[dday9]

Moved to office development where VBA questions go.

[dager6]

Thanks.

I figured it out.

[dday9]

Would you mind posting the solution so that others that visit the thread knows what to do?