2010年项目中嵌套的IIF声明 [英] Nested IIF Statement in Project 2010
问题描述
您好
我是一名IT培训师，我经常教授项目，已经做了多年，但是学生今天要我分类，我不能让它工作，这让我很生气！如果你能给我任何帮助，我将非常感激。
I am an IT Trainer and I teach Project pretty regularly and have done for years, but a student asked me to sort something today and I cannot get it to work, and it is driving me mad! If you can give me any help at all I would be so sincerely grateful.
首先添加了一个新的自定义字段，作为文本字段，因为结果显示在列中显示的文字。
Firstly a new custom field has been added, as a text field, because the outcome with be text that is displayed in the column.
然后在自定义字段公式中我需要输入以下内容但是如何逃避我！：
Then in the custom field formula I need to put the following but how to eludes me!:
如果完成日期是在03/03/14之前或之前 - 我想看到' GL'在现场
If a finish date is on or before 03/03/14 – I would like to see ‘GL’ in the field
如果完成日期在04/03/14 - 03/04/14之间 - 我想在字段中查看"+0"
If a finish date is between 04/03/14 – 03/04/14 – I would like to see ‘+0’ in the field
如果完成日期在04/04/14 - 03/05/14之间 - 我希望在字段中看到'+30'
If a finish date is between 04/04/14 – 03/05/14 – I would like to see ‘+30’ in the field
如果完成日期在04/05/14 - 03之间/ 06/14 - 我希望在字段中看到'+60'
If a finish date is between 04/05/14 – 03/06/14 – I would like to see ‘+60’ in the field
如果完成日期在04/06之间/ 14 - 03/07/14 - 我希望在字段中看到'+90'
If a finish date is between 04/06/14 – 03/07/14 – I would like to see ‘+90’ in the field
如果完成日期是在04/07 / 14-或之后 - 我好我希望在现场看到'BAU'
If a finish date is on or after 04/07/14– I would like to see ‘BAU’ in the field
好的，所以我开始输入 IIF（[完]和< ="03/03/14"，"GL"，""）这不起作用所以在这个阶段还没有尝试做其余的我假设是嵌套的，类似于我的意思在Excel中做。我注意到使用更多的
括号，但不确定，如果我添加更多，则会引发语法错误，当我没有添加额外的括号时，我没有得到。无论如何，我在上面尝试的这个公式给出了两个任务，其完成日期大于语句中的日期！
就好像它忽略了< =并且做了它喜欢的东西，我看到的所有例子都使用了我的操作符。此外，我确保日期格式的输入方式与在项目中设置和显示的格式相同。
OK so I started by entering IIF([Finish]<="03/03/14","GL","") this didn’t work so haven’t at this stage even attempted to do the rest which I assume is nested, similar to what I would do in Excel. I have noticed the use of more
brackets, but not sure and if I add more then it throws a syntax error, which I wasn’t getting when I didn’t add the extra brackets. Anyway this formula I tried above gives GL for two tasks that have a finish date that is greater than the date in the statement!
It is as though it is ignoring the <= and doing what the hell it likes, and all the examples I have seen have used the operators as I have. Also I have ensured that the date format is typed in the same as it is set and displayed in project.
非常感谢任何帮助!!
Any help very gratefully received!!
谢谢Melissa
Melissa Bone
Melissa Bone
推荐答案
Hi Melissa，
Hi Melissa,
我们在此论坛中讨论SQL Server Analysis Services相关问题。为了获得更好的支持，我将把这个帖子移到Project论坛。
http：// social。 technet.microsoft.com/Forums/en-US/home?category=projectserver2010%2Cprojectprofessional2010
We discussion SQL Server Analysis Services related issue in this forum. For better support, I will move this thread to Project forum.
http://social.technet.microsoft.com/Forums/en-US/home?category=projectserver2010%2Cprojectprofessional2010
问候，
这篇关于2010年项目中嵌套的IIF声明的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
