To have a formula return one of two values based on a condition, such as a sales bonus based on a specified sales amount, use the IF worksheet function.

• 若要使公式返回两个基于条件的值之一,例如某指定销售金额的销售红利,可使用IF工作表函数。