[练习题]返回指定字符后的最大数字

knifefox

<p><table cellspacing="0" cellpadding="0" width="463" border="0" xstr="" style="WIDTH: 347pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="403" style="WIDTH: 302pt; mso-width-source: userset; mso-width-alt: 12896;"></col><col width="60" style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 1920;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="403" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 302pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: aqua;"><font face="宋体" color="#800000">数据</font></td><td class="xl25" width="60" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 45pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: lime;"><font face="宋体" color="#800000">结果</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">610.61*26.74+55.53*90.9+14.91*28.22+23.65</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">90.9</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">660.83*698.23+69.57</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">698.23</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">229.06*184.27+9.49*75.41+92.8*48.29</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">184.27</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">966*684.95</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">684.95</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">223.66*732.01+16.18*81.43+27.05</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">732.01</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">748.48*98.12+63.57*72.09+83.74</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">98.12</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">787.46*710.21+48.19*37.9</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">710.21</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">578.27*773.13+8.64</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">773.13</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">875.48*173.78+29.37*49.58</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">173.78</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">817.36*261.29+10.48*31.17</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">261.29</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">554.07*70.2+96.58*14.28+15.19</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">70.2</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">402.93*203.66+79.32*4.45+99.23</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">203.66</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">2+951.89</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">0</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">831.12*360.68+33.26</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">360.68</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">412.65*251.21+92.61*48.19+39.96*26.49</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">251.21</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">176.12*107.43</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">107.43</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">865.91*517.23+81.15*74.19+44.39*12.23</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">517.23</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">583.78*632.14</font></td><td class="xl27" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">632.14</font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl28" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#800000">587.01*68.8+70.78*8.54</font></td><td class="xl29" align="right" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ccffcc;"><font face="宋体" color="#800000">68.8</font></td></tr></tbody></table></p><p><table cellspacing="0" cellpadding="0" width="411" border="0" xstr="" style="WIDTH: 308pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="411" style="WIDTH: 308pt; mso-width-source: userset; mso-width-alt: 13152;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="411" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 308pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#000080">题目要求：提出左面字符串中"*"数据最大的一个。</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font color="#000080"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>如A1：26.74，90.9，28.22<span style="mso-spacerun: yes;">&nbsp; </span>最大的就是90.9</font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#ff0000"><strong>不可以用辅助单元格，不可以用定义名称，不可用VBA</strong></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><strong><font face="宋体" color="#ff0000">跟贴写出公式就可以，好公式给予奖励</font></strong></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font face="宋体" color="#000080">说明：1.最大数不会大于999.99</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font color="#000080"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2.左面的字符串中没有"*"结果返回0</font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font color="#000080"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>3.字符串中"*"和"+"是交替出现的</font></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><font color="#000080"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>4.字符最多是小数点后两位</font></font></td></tr></tbody></table></p><p></p><p></p>

兰色幻想

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

[此贴子已经被作者于2008-5-18 18:58:28编辑过]

cjch1969

<p>学习</p><p></p>

willin2000

<p>

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

willin2000

<p>

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

</p>

E梦

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

[此贴子已经被作者于2008-5-18 19:57:28编辑过]

willin2000

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

亭

学习

hai

<p>

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

</p><p>&nbsp;</p>

guideming

学习