excel公式,如A单元格数值为1,2,3 则B单元格显示为L;如果A单元格为4,5,6 则B单元格显示为M
B1单元格写入公式
=IF(OR(A1={1,2,3}),"L",IF(OR(A1={4,5,6}),"M",""))
excel 中 如果a单元格数值为1,2,3 则b单元格显示为L,如果a单元格为4,5,6则显示为C
B1单元格写入公式
=IF(OR(A1={1,2,3}),"L",IF(OR(A1={4,5,6}),"C",""))
=IF(OR(A1=1,A1=2,A1=3),"L",IF(OR(A1=4,A1=5,A1=6),"M",""))
参考公式:
=LOOKUP(A1,{1,"L";4,"M"})
B单元格输入公式=if(or(a1=1,a1=2,a1=3),L,if(or(a1=4,a1=5,a1=6),C,"范围外")
=IF(A1={1,2,3},"L",IF(A1={4,5,6},"C",""))