20150152有如下Excel2007工作表,销售奖金的计算方法是某种商品销售量大于等于70奖励500元,小于70则没有奖励。要计算的销售奖金,F6单元格中输入函数_(52)_。
A.
=SUM(IF(B6>70,"500"),IF(C6>70,"500"),IF(D6>70,"500")))
B.
=SUMIF(B6>70,"500"),IF(C6>70,"500"),IF(D6>70,"500")))
C.
=IF(B6>70,"500",IF(C6>70,"500",IF(D6>70,"500”)))
D.
=COUNTIF(B6>70,”500”, IF(C6>70,” 500”,IF(D6>70, ”500”)))