This formula is presenting error but I cant find why. I use standard version of Excel 2003.
Thanks=IF((OR(F2="",G2="")),(IF(AND(f2<>"", g2="")),(IF(today()-F2>(WORKDAY(F2,5)),"LATE","OK")),""),(IF(G2-F2>(WORKDAY(F2,5)),"LATE","OK")))
This formula is presenting error but I cant find why. I use standard version of Excel 2003.
Thanks=IF((OR(F2="",G2="")),(IF(AND(f2<>"", g2="")),(IF(today()-F2>(WORKDAY(F2,5)),"LATE","OK")),""),(IF(G2-F2>(WORKDAY(F2,5)),"LATE","OK")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks