I have a project plan where I have created an if statement however second condition is not being evaluated. IF I change the order of the if statements, the first condition is evaluated but not the second.
Correct syntactically but incorrect results the second condition is not being evaluated so the 1 condition is never evaluated if condition 2 is true so I think I need to swap the two and add an additional "and condition to also evaluate the start and finish dates and %complete. I think I need another and condition but it breaks when I that logic to the formula.
Any suggestions ?
IIf([Finish]<=Date() And [% Complete]<>100,2,IIf([Start]<=Date() And [% Complete]=0,1,
IIf([% Complete]=100,3,0)))
__._,_.___
Posted by: lindacsmith3@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar