ISBLANK formula error

I'm trying to use ISBLANK in this formula:

=IF(OR(ISBLANK(P),(LOOKUP(DATEDIF(K3,N3,"m"),{0,2,3},{"On Time","In Progress","Delayed"}),(ISBLANK(N),"")))))))

I want column P to have the formula based on whether there is data in column N. I keep coming back with an error. Any advice?

Originally Posted by CK76

So which column is supposed to house the formula? Column P?

Then ISBLANK should point to column N at specific cell, not entire column.

Something like...

=IF(ISBLANK(N3),"",LOOKUP(DATEDIF(K3,N3,"m"),{0,2,3},{"On Time","In Progress","Delayed"}))

This worked though, thank you!

Ugh...I cut some extra columns out before I uploaded it. Column I should house the formula, reflecting data entered into column G.

You are welcome and thanks for the rep