[已解决]请大虾 帮忙做两个公式

du168

通过A列的数据， 做出B列 和C列的公式   

要求是结果显示要一样     

请大虾帮忙     

最佳答案

月排行榜 / 总排行榜

qinqh_yl

2015-4-24 11:16

如果０算“质数”：
B1=IF(OR(--LEFT(A1)={4,6,8,9}),"合-","质-")&IF(OR(--MID(A1,2,1)={4,6,8,9}),"合-","质-")&IF(OR(--RIGHT(A1)={4,6,8,9}),"合","质")

C1=IF(--LEFT(A1)<5,"小-","大-")&IF(--MID(A1,2,1)<5,"小-","大-")&IF(--RIGHT(A1)<5,"小","大")

跳转到最佳答案楼层

qinqh_yl

如果０算“质数”：
B1=IF(OR(--LEFT(A1)={4,6,8,9}),"合-","质-")&IF(OR(--MID(A1,2,1)={4,6,8,9}),"合-","质-")&IF(OR(--RIGHT(A1)={4,6,8,9}),"合","质")

C1=IF(--LEFT(A1)<5,"小-","大-")&IF(--MID(A1,2,1)<5,"小-","大-")&IF(--RIGHT(A1)<5,"小","大")

du168

qinqh_yl 发表于 2015-4-24 11:16
如果０算“质数”：
B1=IF(OR(--LEFT(A1)={4,6,8,9}),"合-","质-")&IF(OR(--MID(A1,2,1)={4,6,8,9}),"合-" ...

0  属于合数