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?
Bookmarks