Try this:
=IFERROR(IF(AND(CM39=1,FIND("completed",W39)>0,AA39<>"Payment On Account"),1,0),0)
Try this:
=IFERROR(IF(AND(CM39=1,FIND("completed",W39)>0,AA39<>"Payment On Account"),1,0),0)
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks