Gareth Horton
July 12th, 2002, 01:51 PM
Heather wrote:
> Hi,
>
> I am trying to create a multiple if statement. Example, if column job is =
> DSZM752A then put FED otherwise leave it blank, if column
> Job is = DSZM752 then put AMER otherwise leave it blank.
>
> If (JOB="DSZM752A","FED", "",,$s:LF> If (JOB="DSZM752","AMER",""))
>
> I keep getting Invalid delimiter and or Operand count.
>
> Can anyone see what I am missing?
>
> Also I am a registered
> Monarch user and I am not receiving a copy of the Monarch Report newsletter.
> Does anyone no how I can get a copy?
>
> Thanks,
> Heather
>
The correct structure should be
If (JOB="DSZM752A","FED",If (JOB="DSZM752","AMER",""))
You can't have the "" in the middle of the line.
Your second if statement is your first else statement.
Hopefully, that makes sense.
Joel Heyman
> Hi,
>
> I am trying to create a multiple if statement. Example, if column job is =
> DSZM752A then put FED otherwise leave it blank, if column
> Job is = DSZM752 then put AMER otherwise leave it blank.
>
> If (JOB="DSZM752A","FED", "",,$s:LF> If (JOB="DSZM752","AMER",""))
>
> I keep getting Invalid delimiter and or Operand count.
>
> Can anyone see what I am missing?
>
> Also I am a registered
> Monarch user and I am not receiving a copy of the Monarch Report newsletter.
> Does anyone no how I can get a copy?
>
> Thanks,
> Heather
>
The correct structure should be
If (JOB="DSZM752A","FED",If (JOB="DSZM752","AMER",""))
You can't have the "" in the middle of the line.
Your second if statement is your first else statement.
Hopefully, that makes sense.
Joel Heyman