当B列为"1"或者"2"或者"3" 则A列显示为"A" 当B列为"4"或者"5"或者"6",则A列显示为"B"

2025-03-04 13:34:47
推荐回答(2个)
回答1:

你说的是在Excel中实现吗?

在A列用公式“=IF(B6<=3,"A","B")”即可 如图 

A1单元格中输入“=IF(B1<=3,"A","B")”

A2单元格中输入“=IF(B2<=3,"A","B")”

A3单元格中输入“=IF(B3<=3,"A","B")”

A4单元格中输入“=IF(B4<=3,"A","B")”

或者A1单元格输入完之后往下一拉就行

回答2:

对哦,你是要用C#还是要在excel里面实现?
C#的话还是可以:
A值=(B值.contains("英俊") ||B值.contains("潇洒") ||B值.contains("帅气"))?"我":"你"