adding formula

[Majid]

Hello Dear,
I am trying to add two formulas in one column and I am getting an error. If
I have the fisrt part of the formula in tha same column it works
ProjDateSub(Finish1,2320) OR ProjDateSub(Start10,1440)
Plesae advise
Thank you
Majid

 

[Chris Marriott]

Majid

Any formula that includes an AND or OR statement requires surounding
parentheses e.g.

(ProjDateSub(Finish1,2320) OR ProjDateSub(Start10,1440))

This would also have to be a part of a bigger formula e.g.

iif((ProjDateSub(Finish1,2320) OR ProjDateSub(Start10,1440)),1,2)

I hope this helps .... let me know
--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer

 

[JackD]

Don't you need the square brackets around the fields?

ie: [Start10]

Troubleshooting online is easiest if you provide exact information. Cutting
and pasting the actual formula is best.

 

[Chris Marriott]

Hi

Square brackets are only required if there are spaces in the field name but
usually I do use them as standard with or without spaces ....


--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer

Don't you need the square brackets around the fields?

ie: [Start10]

Troubleshooting online is easiest if you provide exact information. Cutting
and pasting the actual formula is best.
--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

Majid

Any formula that includes an AND or OR statement requires surounding
parentheses e.g.

(ProjDateSub(Finish1,2320) OR ProjDateSub(Start10,1440))

This would also have to be a part of a bigger formula e.g.

iif((ProjDateSub(Finish1,2320) OR ProjDateSub(Start10,1440)),1,2)

I hope this helps .... let me know
--
Regards


Chris Marriott - PMP MCSE MCDBA
UK - EPM Consultant & Trainer

 

[Majid]

Hello Chris and thank you for your advice
I have plugged in the formua but it is not working!
I am getting #ERROR in the column.
I have tried iif formula and still is not working
I even tried jack advice and put bracket around the field name and it did
not work
Please advise thank you
Majid

 

[Majid]

Hello Chris,
Following this formula my colleague and I tried to make it work but it seems
OR is not responding also I do not undrestand 1,2 at the end of iif formula
Please advise thank you Majid