Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or
[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime',1))
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
for syntax maybe
=COUNT(IF( ([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or
([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime')
,1) )
=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime') or
([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime'),1)
=COUNT(IF([STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime' or
[STATUS_SP] = 'Evaluate' and [EVAL_ONTIME] = 'OnTime',1))
thanks all, I really appreciate it, that did it.
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