Using IF and OR

[leocattqv]

Hi All,

I have a list of Step status in records and I need to determine late and overdue.  this is what I have so far, but I get an error out.

Any suggestions?

=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or

( if([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'),1)

[rwunderlich]

The red indicates unbalanced parens, And there appear to be no difference between the two ifs. I think this is what you want.

=COUNT(

IF(([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime')

,1)

)

-Rob

[maxgro]

for syntax maybe

=COUNT(IF(    ([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or

                      ([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime')

            ,1) )

[Anonymous]

=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or
([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'),1)

[MarcoWedel · Accepted solution]

=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or

[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime',1))

[leocattqv]

thanks all, I really appreciate it,  that did it.

[MarcoWedel]

Hi,

rwunderlich  is right,

[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or [STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'

is equal to

[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'

so his solution might be the better choice if this is, what you are looking for.

regards

Marco