关键字:excel 更新时间:2021-03-31 04:18:58 104次访问
=IF(ISODD(A2),"奇","")
=IF(ISEVEN(A2),"偶","")
=IF(B2="","偶","")
一个公式解决的:
=IF(AND(ISODD($A2),COLUMN()=2),"奇",IF(AND(ISEVEN($A2),COLUMN()=3),"偶",""))
相关标签:excel
下一篇:写程序段运行结果
上一篇:可以帮忙做单片机的毕业设计吗