2.5
KINLONG
Home
Profiles
▼
Communities
▼
Apps
▼
Metrics
Moderation
首页
▼
Log In
Share
?
IBM
Blogs
My Blogs
Public Blogs
My Updates
Administration
Log in
to participate
▼
Tags
▼
Archive
June 2017
May 2017
▼
Blog Authors
办公软件操作交流
View All Entries
Clicking the button causes a full page refresh. The user could go to the "Entry list" region to view the new content.)
Entry list
通过今天的演讲比赛发现的公式：去掉一个最高分、去掉一个最低分后取平均值
王赟
d1fb6640-b761-1036-92bd-ef16cba5f6da
wangyun2@kinlong.cn
|
|
6 Comments
|
320 Views
=TRIMMEAN(D12:J12,2/COUNT(D12:J12)) D2-D12是指在这一列数据中去除一个最高分和一份最低分，计算其中剩余数据的平均值。
Modified on by
王赟
d1fb6640-b761-1036-92bd-ef16cba5f6da
wangyun2@kinlong.cn
Add a Comment
Add a Comment
Edit
More Actions
v
Quarantine this Entry
Notify Other People
notification
Send Email Notification
Type in a Name:
+
Notify:
Message:
Quarantine this entry
Provide a reason for quarantining this blog entry (optional):
deleteEntry
duplicateEntry
Mark as Duplicate
Find the duplicate idea:
Previous Entry
Main
Next Entry
Feed for Blog Entries
|
Feed for Blog Comments
|
Feed for Comments for this Entry
Home
Help
IBM Support Forums
Bookmarking Tools
Server Metrics
Mobile UI
About
IBM Connections on ibm.com
Submit Feedback
