天气预报15天查询> 生活> excel合格率怎么算

excel合格率怎么算

更新时间: 2021-01-30 03:03:16     

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

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

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

关键词: excel 合格率 怎么

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-2385808/ | 耗时:0.9055 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
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)