if()

The function if (or iif ) has three parameters: if the first parameter is not 0/true, the second parameter will be returned, otherwise the third parameter. For example:

if([Checkbox];"yes";"no")

If the additional checkbox field is checked, the expression returns yes and no otherwise.
The third parameter can also be omitted. Then, the function returns NULL in the false case.