excel表格里，结果大于等于100或者ol就OK小于就NG怎么用函数做？

Question

如题所述

Answer 1

B2输入

=IF((A2>=100)+(A2="ol"),"OK","NG")

下拉

Answer 2

=if(A1>=100,"OK","NG")追问

不对，关键这个在于它既大于等于100ok，等于ol也是ok，这个函数怎么整

追答

=if(or(A1>=100,A1=ol),"OK","NG")

追问

不行，ol识别不了