Excel公式求助

显示全部楼层 · 2013-5-25 23:04:54

判断单双的公式是：=IF(ISODD(A1),"单","双")=IF(ISEVEN(A1),"双","单")=IF(MOD(A1,2)=0,"双","单")判断大小的公式是：=IF(A14,"大","小")判断质数合数的公式是：=IF(AND(INT(A1)=A1,A1>1),IF(SUMPRODUCT((MOD(A1,ROW($1:$9999))=0)*1)>2,"合数","质数"),"")但按你的要求，公式应该改为如下：=IF(SUMPRODUCT((MOD(A1,ROW($1:$9999))=0)*1)>2,"合数","质数") 以上公式，你想在哪个单元格出结果，...

千问 · 2013-5-25 23:04:54

在B1 C1 中公式 =if(mod(A1,2),“单“,"双")在B1 C1中公式=if(A1<5,"小","大")在B1 C1中公式=if(OR(A1={1,2,3,5,7}),”质",“合”）...

千问 · 2013-5-25 23:04:54

1、=IF(ISODD(A1),"单","双")2、=IF(A1<5,"小","大")3、=IF(OR(A1={1,2,3,5,7}),"质","")...

千问 · 2013-5-25 23:04:54