ISBlank question

JimTod

I am trying to return a 0 if my date is blank, if not I want to return a 1 if the date is greater to another date or return a 2 if the date is less than or equal to the other date.

here is the formula I am trying to use

=IF(ISBLANK([Due date]@row, 0, IF([Due date]@row > date@row, 1, IF([Due date]@row <= date@row, 2))))

Samuel Mueller

=IF(ISBLANK([Due date]@row), 0, IF([Due date]@row > date@row, 1,2))

This should work

Yours also works in concept you just put the Parentheses in the wrong place. Need one after the isblank, and then remove one from the end.

Samuel Mueller

=IF(ISBLANK([Due date]@row), 0, IF([Due date]@row > date@row, 1,2))

This should work

Yours also works in concept you just put the Parentheses in the wrong place. Need one after the isblank, and then remove one from the end.

JimTod

thank you!!