This formula is presenting error but I cant find why. I use standard version of Excel 2003.
ThanksPlease Login or Register to view this content.
This formula is presenting error but I cant find why. I use standard version of Excel 2003.
ThanksPlease Login or Register to view this content.
It's extremely difficult to take a formula that doesn't work, and "fix" it if we don't know what it's supposed to do.
It's far easier if you can explain in words what you want the formula to do.
this is a guess since it's not real clear as Jonmo1 said
=IF(F2<>"",IF(G2="",IF(TODAY()>WORKDAY(F2,5),"LATE","OK"),IF(G2>WORKDAY(F2,5),"LATE","OK")),"")
Josie
if at first you don't succeed try doing it the way your wife told you to
As Jonmo says, hard to say without seeing what you are referencing, but it looks like you have a bunch of extra )
=IF(OR(F2="",G2=""),IF(AND(f2<>"", g2=""),IF(today()-F2>WORKDAY(F2,5),"LATE","OK"),""),IF(G2-F2>WORKDAY(F2,5),"LATE","OK"))
Try to only use as many () as you need, adding extras only makes the chance of errors greater, and makes it harder to debug
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks