在b1单元格中输出如下公式：
=IF(MOD(A1,2)=0,"偶","奇")

在B1中输入公式：=IF(MOD(A1,2)=1,"奇","偶")。mod是取余数，if是条件判断。

在B1里面输入下面公式：=IF(MOD(A1,2)=1,"奇","")。

你可以在B1单元格中加入以下公式 =IF(MOD(A1,2)=0,"","奇数")

给一个拓展性较强的公式：
=CHOOSE(RIGHT(A1,1)*1+1,&日夏养花网quot;","你好","再见","","","","","","","",)
尾数不同，显示不同，在公式的引号中间添加需要显日夏养花网示的字就可以，可以预置10个。

=if(right(a1)="1","你好",if(right(a1)="2","再见",""))
或
=if(right(a1)*1=1,"你好",if(right(a1)*1=2,"再见",""))

=if(--right(a1)=1,"你好",if(--(right(a1)=2,"再见",""))

=CHOOSE(--right(A1),"你好","再见")

在B1中输入公式
=IF(MOD(A1,3)=0,0,"")

B1单元格写入公式
=IF(A1="",&qu日夏养花网ot;",IF(OR(A1={1,2}),"木",IF(OR(A1={3,4}),"火",IF(OR(A1={5,6}),"土",IF(OR(A1={7,8}),&quo日夏养花网t;金",IF(OR(A1={9,0}),"水",""))))))
或
=IF(A1="","",CHOOSE(A1+1,"水","木","木","火","火","土","土","金","金","水"))
再或
=IF(A1="","",LOOKUP(A1,{0,"水";1,"木";3,"火";5,"土";7,"金";9,"水"}))

=IF(A1="","",MID("木火土金水",IF(A1=0,5,INT((A1+1)/2)),1))

=IF(OR(A1=5, A1=6),"土", IF(OR(A1=7,A1=8),"金", IF(OR(A1=9,A1=0),"水","其它值")))
最后一个其它值，用于指定不是以上情况时的显示，你可以自己改。