Question

To assign a conditional value, use the ____ function.

Answer 1

To assign a conditional value, use the IFF function.  It is an abbreviation for  Immediate If.  It is a function on spreadsheets that returns the second or third parameter based on the evaluation of the first parameter.  You use IIf to determine if another expression is true or false. If the expression is true, 
IIf returns one value; if it is false, IIf returns another.