=IF(M13>0,"POSTED",IF(D13="","CONFIRMED",IF(D13>0,"DOOR",IF(N13>0,"WAITING"))))
The above formula is done with conditional formatting but it calculates everything except the last part if(N13>0"WAITING"))))
I do not know why this is for a Inbound schedules and with this it will track when the truck is here, in the door, and gone.
Any help will be greatly appreciated
Thanks!
Hello janberto09,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks