Help with ISERROR

Hi

 

I am trying to add the ISERROR to the below formula.  I am calculating between dates to return a value or sum the amount of months in between and when $I$2 (which  is the current period) is greater than D6 (period end) I get the #NUM! error.  I am guessing this is because it is returning a minus which it doesn’t like.  If I ca return this as a 0 then my spreadsheet will work.

 

=IF($I$2>C6,MONTH(D6-$I$2)-1,E6)

By: llhbaiey

One thought on “Help with ISERROR

  1. lllhbailey

    I figured it out.

    =IF(ISERROR(IF($I$2>C6,MONTH(D6-$I$2)-1,E6)),0,IF($I$2>C6,MONTH(D6-$I$2)-1,E6))

Leave a Reply

Your email address will not be published. Required fields are marked *