求EXCEL公式

2024-12-18 11:40:32
推荐回答(5个)
回答1:

H列的公式为:=IF(MOD(C1,2)=0,"双",""),J列的公式为:=IF(MOD(C1,2)<>0,"单",""),不懂继续可以问,忘采纳

回答2:

H1=IF(C1/2=ROUND(C1/2,0),"双","")
JI=IF(C1/2<>ROUND(C1/2,0),"单","")
这个公式就是判定C1值除以2是否等于C1值除以2的正整数,不等于就是单,等于就是双。

回答3:

在H1中输入或复制粘贴下列公式
=IF(COUNT(C1)=0,"",IF(ISODD(C1),"单","双"))
下拉填充

=IF(COUNT(C1)=0,"",IF(ISEVEN(C1),"双",""))
=IF(COUNT(C1)=0,"",IF(ISODD(C1),"单",""))
选择H1、J1,分别下拉填充

回答4:

H1=IF(C1="","",IF(MOD(C1,2)=0,"双",""))
J1=IF(C1="","",IF(MOD(C1,2)<>0,"单",""))
两个公式下拉即可、

回答5:

在H1中输入公式

=IF(AND(LEN(C1)=1,MOD(C1,2)=1),"","双")
在J1中输入公式
=IF(AND(LEN(C1)=1,MOD(C1,2)=1),"单","")