Question

求助：excel公式，如A单元格数值为1,2,3 则B单元格显示为L；如果A单元格为4,5,6 则B单元格显示为M

如：excel 中 如果a单元格数值为1,2,3 则b单元格显示为L,如果a单元格为4,5,6则显示为C
公式如何设定，请excel大神帮忙，谢了！

Answer 1

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",""))

Answer 2

=IF(OR(A1=1,A1=2,A1=3),"L",IF(OR(A1=4,A1=5,A1=6),"M",""))

Answer 3

参考公式：
=LOOKUP(A1,{1,"L";4,"M"})

Answer 4

B单元格输入公式=if(or(a1=1,a1=2,a1=3),L,if(or(a1=4,a1=5,a1=6),C,"范围外")

Answer 5

=IF(A1={1,2,3},"L",IF(A1={4,5,6},"C",""))