如题所述
第1个回答 2011-12-01
把以下公式复制到A10单元格,然后再选中A10单元格,按Shift+Ctrl+Enter三键组合键:
=IF(OR(A1:A9={0,1,2,3,4,5,6,7,8}),9,"无")
=IF(OR(A1:A9={0,1,2,3,4,5,6,7,8}),9,"无")
第2个回答 2011-12-01
在A10输入:
=IF(SUM(COUNTIF(A1:A9,{0,1,2,3,4,5,6,7,8})),9,"")本回答被提问者采纳
=IF(SUM(COUNTIF(A1:A9,{0,1,2,3,4,5,6,7,8})),9,"")本回答被提问者采纳