EXCEL 中A1=1则B1=7,A1=2则B1=5,A1=3则B1=4,A1=4则B1=3

2025-04-14 23:50:24
推荐回答(1个)
回答1:

B1用公式:
=IF(OR(A1={1,2,3,4}),"rt","")