Iff statement

PeterK · Feb 4, 2004

I am trying to use an "If" statment in a report but having
no luck.

Example: =iff([Temperature]="1", "Hot", "Cold")

Any suggestions?

THX

Les · Feb 4, 2004

It should be IIF instead of iff.

Peter Cole · Feb 5, 2004

Try IIF as otherwise it's ok
Peter C