How to ignore the formula if DO# is blank in a row
TAT DAYS =IF(AND(DO#<>"", CLOSED DATE<>""),CLOSED DATE-DEL DATE, "")
# of Days Pending =IF(CLOSED DATE="",TODAY()-DEL DATE,IF(CLOSED DATE<>"",""))
Remarks =IF(CLOSED DATE<>"","COMPLETED",IF(# OF DAYS PENDING>=30,"FOLLOW UP SALES",""))
No PO Delivery.xlsx
Last edited by angie_lin; 01-12-2024 at 01:59 AM.
Maybe:copied down.Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
For example please try in I3 and copy down:Formula:Please Login or Register to view this content.
Thank you so much
You are Welcome! Thanks for the rep.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks