函入班第4讲8组上交作业帖

jyh197994

[em01]

huangyang

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

<table cellspacing="0" cellpadding="0" width="72" border="0" xstr="" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="72" height="19" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 54pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第一题:=VLOOKUP(C2,$H$4:$I$8,2)*C2</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第二题:=VLOOKUP(C2,$H$4:$I$8,2)*C2[/hide]</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第三题:=C2*LOOKUP(C2,CHOOSE({1,2},$H$4:$H$8,OFFSET($H$4,0,MATCH($B2,$I$3:$L$3,0),5,1)))</td></tr></tbody></table>

yuezhao_cn

交作业 B8dUZ57V.rar (8.64 KB, 下载次数: 3)

2008-6-16 23:28 上传

点击文件名下载附件
函入班第4讲8组上交作业帖 <br/>

张琳琳

<p>学习学习</p>[em07]

zxy_5639

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

vbyou127

96696656