天气预报 > 其他 > excel中如何判断奇数偶数呢
excel中如何判断奇数偶数呢
更新时间: 2020-11-19 00:00:00  

快速判断奇偶数的方法,赶紧收藏吧!

方法/步骤1公式=if(mod(A2,2)=0,"偶数","奇数"),如果余数是0,则为偶数;反之为奇数

2公式=if(iseven(A2),"偶数","奇数"),

关键词: excel 如何 判断 奇数 偶数

excel中如何判断奇数偶数呢相关经验

天气预报

最新推荐

页面:/news/view-807905/ | 耗时:0.3184 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=807905 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=807905 LIMIT 0,1
select * from tbl_Articles_sphinx where id=807905 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1127271,844543,915935,1085874,1062985,1284808,1848140,1094255,199739,585298,1526910,889991,331136,1732893,1078226,1667855,1653154,1488278,810309,961185,1717889,888536,1069401,2360279,1117850,472972,1099827,1042066,1601302,1991554) ORDER BY field (ArticleID,1127271,844543,915935,1085874,1062985,1284808,1848140,1094255,199739,585298,1526910,889991,331136,1732893,1078226,1667855,1653154,1488278,810309,961185,1717889,888536,1069401,2360279,1117850,472972,1099827,1042066,1601302,1991554)