adding formula

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
Sat Nov 19 09:36:03 CST 2005

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" wrote:

>
> 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

JackD
Sat Nov 19 10:41:48 CST 2005

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
.
"Chris Marriott" <chris.marriott@intellient.com> wrote in message
news:128EE1AC-7DBC-49E5-8EB9-1030C5FBB047@microsoft.com...
> 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" wrote:
>
> >
> > 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
Sat Nov 19 17:18:02 CST 2005

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


"JackD" wrote:

> 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
> ..
> "Chris Marriott" <chris.marriott@intellient.com> wrote in message
> news:128EE1AC-7DBC-49E5-8EB9-1030C5FBB047@microsoft.com...
> > 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" wrote:
> >
> > >
> > > 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
>
>
>

Majid
Mon Nov 21 08:20:06 CST 2005

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

"Chris Marriott" wrote:

> 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" wrote:
>
> >
> > 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

Majid
Mon Nov 21 14:56:02 CST 2005

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

"Majid" wrote:
> 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
>
> "Chris Marriott" wrote:
>
> > 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" wrote:
> >
> > >
> > > 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