General discussion

Locked

IIf this than this?

By natasha.epperson ·
My Origional formula for my report was this:

=IIf([AfterFact]="1","Y","N")

However I need to tell the field that if it's 1 or 2 = Y, Null or 3 = N

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by PubServant In reply to IIf this than this?

Try this.
IIf([AfterFact]="1" Or [AfterFact]="2","Y",IIf([AfterFact]="3" Or IsNull([AfterFact]),"N","Other Value"))

Collapse -

by natasha.epperson In reply to

Poster rated this answer.

Collapse -

by natasha.epperson In reply to IIf this than this?

hehe, kept playing around....
This is what I came up with that worked.
=IIf([AfterFact]="1" Or [AfterFact]="2","Y","N")

Collapse -

by natasha.epperson In reply to IIf this than this?

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums