函数测试题

shgxf520

<p>

函数测试题

<br/></p><p>以上题目中，用哪个函数分别算出后面的人数呢？</p><p>请写出公式，正确的分别奖励10个BB.前三名，分别是10个BB，8个BB，5个BB。</p>

[此贴子已经被作者于2010-1-8 20:12:05编辑过]

影月小筑

游客，如果您要查看本帖隐藏内容请回复

fuzp

<table cellspacing="0" cellpadding="0" width="72" border="0" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="18" style="HEIGHT: 13.5pt;"><td width="72" height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=COUNTIF(B2:B10,"&lt;=400")-COUNTIF(B2:B10,"&lt;200")</td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=COUNTIF(B2:B10,"&lt;200")</td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=COUNTIF(B2:B10,"&lt;=800")-COUNTIF(B2:B10,"&lt;400")</td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=COUNTIF(B2:B10,"&gt;1000")</td></tr></tbody></table>

quanwang_lu

<p>

游客，如果您要查看本帖隐藏内容请回复

</p>

fuzp

<table cellspacing="0" cellpadding="0" width="461" border="0" style="WIDTH: 346pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="461" style="WIDTH: 346pt; mso-width-source: userset; mso-width-alt: 14752;"></col></colgroup><tbody><tr height="18" style="HEIGHT: 13.5pt;"><td width="461" height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 346pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=FREQUENCY($B$2:$B$10,199)</td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=FREQUENCY($B$2:$B$10,400)-FREQUENCY($B$2:$B$10,199.9)</td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=FREQUENCY($B$2:$B$10,800)-FREQUENCY($B$2:$B$10,399)</td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td height="18" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;">=COUNT(B2:B10)-FREQUENCY($B$2:$B$10,1000)</td></tr></tbody></table>[em05]

shgxf520

<font color="#ff0000"><strong>大家还是很不错哟。[</strong></font>em07]

菜鸟一位

=FREQUENCY($B$2:$B$10,199)
=FREQUENCY($B$2:$B$10,400)-FREQUENCY($B$2:$B$10,199.9)
=FREQUENCY($B$2:$B$10,800)-FREQUENCY($B$2:$B$10,399)
=COUNT(B2:B10)-FREQUENCY($B$2:$B$10,1000)

vbyou127

fggdffd