1) The AND function checks multiple conditions a) all must be TRUE b) only one needs to be TRUE 2) The OR function checks multiple conditions a) all must be TRUE b) only one needs to be TRUE. 3) If A1 = 70, what will the formula =IF(A1>=60,"Pass","Fail") return? a) Pass b) Fail 4) If you want a formula to return TRUE when either condition is met, which function should you combine with IF? a) AND b) OR

IF Function

由
打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？