Stop Light Formula
in [Project]
|
Prev: problems migrating project2k3server data to project2k7server
Next: How do we remove the icon "This Assignment work has been edited" ?
From: texmaster on 8 Oct 2009 16:50 Hi Everyone. I've tried pasting this formula into a number field as described but I continue to get a syntax error and it highlights the second [Finish Variance] Switch([Finish Variance]/[Minutes Per Day]<=5,1,[Finish Variance]/[Minutes Per Day]>5 And [Finish Variance]/[Minutes Per Day]<=10,2,[Finish Variance]/[Minutes Per Day]>10,3) What am I doing wrong? -- texmaster ------------------------------------------------------------------------ texmaster's Profile: http://forums.techarena.in/members/142408.htm View this thread: http://forums.techarena.in/microsoft-project/1088751.htm http://forums.techarena.in
From: Andrew Lavinsky on 8 Oct 2009 18:18
Strange. Works just fine when I paste it into a number field. Have you tried it in another file? Try copy/pasting again? - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > Switch([Finish Variance]/[Minutes Per Day]<=5,1,[Finish > Variance]/[Minutes Per Day]>5 And [Finish Variance]/[Minutes Per > Day]<=10,2,[Finish Variance]/[Minutes Per Day]>10,3) > |