天气预报 > 生活 > excel合格率怎么算
excel合格率怎么算
更新时间: 2021-01-30 03:03:16  

1、打开“Excel”,点击及格率后方单元格,输入“=COUNTIF(C2:C9,>=90)/COUNTA(C2:C9)”。

2、点击上方的“√”可以计算出数学的及格率。

3、把鼠标移到单元格右下角,点击拉到右边即可计算出语文和英语的及格率。

关键词: excel 合格率 怎么

excel合格率怎么算相关经验

天气预报

最新推荐

页面:/news/view-2385808/ | 耗时:0.5024 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2385808 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2385808 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2385808 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1130099,1108283,1063453,1103961,1101363,1126726,1125984,1130083,1063609,1129015,1110285,1124973,1130774,1094049,1131815,1122559,1123851,1129521,1117674,1046092,1122406,1123899,1108900,1056488,1122691,1121394,985152,989221,1107847,1115771) ORDER BY field (ArticleID,1130099,1108283,1063453,1103961,1101363,1126726,1125984,1130083,1063609,1129015,1110285,1124973,1130774,1094049,1131815,1122559,1123851,1129521,1117674,1046092,1122406,1123899,1108900,1056488,1122691,1121394,985152,989221,1107847,1115771)