|
楼主 |
发表于 2007-2-25 19:09
|
显示全部楼层
<table cellspacing="0" cellpadding="0" width="690" border="0" xstr="" style="WIDTH: 518pt; BORDER-COLLAPSE: collapse;"><colgroup><font size="5"><col width="690" style="WIDTH: 518pt; mso-width-source: userset; mso-width-alt: 22080;"></col></font></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl25" width="690" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><strong><font color="#800000" size="5">19、MAX函数</font></strong></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="690" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><strong><font color="#800000" size="5"></font></strong></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl26" width="690" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>函数名称:</strong></font><font class="font5">MAX</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="690" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl26" width="690" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>主要功能:</strong></font><font class="font5">求出一组数中的最大值。</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="690" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl26" width="690" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>使用格式:</strong></font><font class="font5">MAX(number1,number2……)</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="690" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="39" style="HEIGHT: 29.25pt;"><td class="xl26" width="690" height="39" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 29.25pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>参数说明:</strong></font><font class="font5">number1,number2……代表需要求最大值的数值或引用单元格(区域),参数不超过30个。</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="690" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="39" style="HEIGHT: 29.25pt;"><td class="xl26" width="690" height="39" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 29.25pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>应用举例:</strong></font><font class="font5">输入公式:=MAX(E44:J44,7,8,9,10),确认后即可显示出E44至J44单元和区域和数值7,8,9,10中的最大值。</font></font></td></tr><tr height="10" style="HEIGHT: 7.5pt; mso-height-source: userset;"><td class="xl24" width="690" height="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 7.5pt; BACKGROUND-COLOR: transparent;"><font size="5"></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl26" width="690" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 518pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font size="5"> <font class="font6"><strong>特别提醒:</strong></font><font class="font5">如果参数中有文本或逻辑值,则忽略。</font></font></td></tr></tbody></table> |
|