1、首先利用AND函数来说明同时满足多个条件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a08b87d6277f9e2f86e0ae740f30e924b999f3f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、如果A列的文本是“A”,并且B列的数据大于210,则在C列标注“Y”,在C2输入公式=IF(AND(A2=“A”,B2>210),“Y”,“”)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/10dfa9ec8a136327f738714f818fa0ec09fac7f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、每个条件和标准都去判断是否相等,如果等于返回TRUE,否则返回FALSE,只有所有的条件和判断均返回TRUE,也就是所有条件都满足时AND函数才会返回TRUE。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a465ff738457b63f6246a60aff1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后利用OR函数来说明,只要满足多个条件中的一个或一个以上条件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15cef43b5375a6003af33b87b2f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、如果A列的文本是“A”,或者B列的数据大于150,则在C列标注“Y”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5882b2b7d0a20cf4ea454da366094b36adaf99f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)