求IF函数表达方法,如果A1、B2/B3/B3/.B100或者B1/C1/D1/E1/F1.nn1里面含有X则A1为X,否则为空!求函数我要的是一整行或则一整列里面有X,那么A1就是X!在线坐等回答

Question

求IF函数表达方法,
如果A1、B2/B3/B3/.B100或者B1/C1/D1/E1/F1.nn1里面含有X则A1为X,否则为空!求函数
我要的是一整行或则一整列里面有X,那么A1就是X!在线坐等回答

Answer 1

A1单元格写入公式
=IF(COUNTIF(B1:B100,"X"),"X","") B1至B100单元格中有某单元格内容为"X",则返回"X"
=IF(COUNTIF(B1:NN1,"X"),"X","") B1至NN1单元格中有某单元格内容为"X",则返回"X"
或者你是要
=IF(COUNTIF(B1:B100,"*X*"),"X","") B1至B100单元格中有某单元格内容包含有"X",则返回"X"
=IF(COUNTIF(B1:NN1,"*X*"),"X","") B1至NN1单元格中有某单元格内容包含有"X",则返回"X"