The IIf Function
This function is a kind of short cut to writing «If()» … «Else()» … «End()» in certain circumstances. Using If.. Else.. End: Suppose you want to write something like The amount of VAT applicable is …. Where the …. above is either zero, if no VAT is applicable, or