ISBlank question

Question

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 · Accepted Answer

=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.