Senin, 15 Juni 2015

[ExcelVBA] Inline if will not evaluate second condition

 

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

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar