一、在excel中如何判断
首先是质数的概念，满足下列条件的，才能算是质数：
正整数；不等于1；只能被1和自身整除
你的A1:J1的区域中是否保证了都是正整数？否则还要判断整数，这个if语句就很长了。。。
所以先添加辅助行：在A2中输入数组公式：
{=IF(A1=1,"非质非合",IF((A1<4)+MIN(MOD(A1,ROW(INDIRECT("2:"&INT(A1^0.5))))),"质数","合数"))}
{}是通过ctrl+shift+enter来确定的，不是手输的哦~
然后复制到B2到J2
在A3中输入公式，开始计数：
=COUNTIF(A2:J2,"质数")
二、EXCEL里怎么判断质
B1=IF(AND(A1>=4,A1=INT(A1)),IF(OR(INT(A1/ROW(INDIRECT("3:"&INT(SQRT(A1)))))*ROW(INDIRECT("3:"&INT(SQRT(A1))))=A1)," ","质"),IF(OR(A1={2,3}),"质"," ")) C1=IF(AND(A1>=4,A1=INT(A1)),IF(OR(INT(A1/ROW(INDIRECT("3:"&INT(SQRT(A1)))))*ROW(INDIRECT("3:"&INT(SQRT(A1))))=A1),"合"," "),IF(OR(A1={2,3})," "," "))
