条件1:X>=99、99>x>=90、x<90具体如下
=IF(B2>=99,"A",IF(B2>=90,"B","C"))
如果D列空白地方为空,就这个公式=IF(B2="","",IF(B2>=99,"A",IF(B2>=90,"B","C")))具体如下:
=IFS(B2>=99,"A",B2>=90,"B",B2<90,"c")
判断为空的格式
=IFS(B2="","",B2>=99,"A",B2>=90,"B",B2<90,"c")
条件1:X>=99、99>x>=90、x<90具体如下
=IF(B2>=99,"A",IF(B2>=90,"B","C"))
如果D列空白地方为空,就这个公式=IF(B2="","",IF(B2>=99,"A",IF(B2>=90,"B","C")))具体如下:
=IFS(B2>=99,"A",B2>=90,"B",B2<90,"c")
判断为空的格式
=IFS(B2="","",B2>=99,"A",B2>=90,"B",B2<90,"c")