[练习题]返回指定字符后最大数字（2）

knifefox · 发表于 2008-5-20 10:32

<table cellspacing="0" cellpadding="0" width="523" border="0" xstr="" style="WIDTH: 392pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="451" style="WIDTH: 338pt; mso-width-source: userset; mso-width-alt: 14432;"></col><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: aqua;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;">数据</div></td><td class="xl25" width="72" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: lime;">结果</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">-610.61*26.74-55.53*90.9-14.91*28.22+23.65</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">90.9</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">*660.83*698.23-699.57+2</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">698.23</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">-229.06*184.27+9.49*75.41+92.8*48.29</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">184.27</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">966*684.95/12</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">684.95</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">223.66*732.01*16.18*81.43+27.05</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">732.01</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">748.48*98.12+63.57*72.09+83.74</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">98.12</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">787.46*710.21+48.19*37.9</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">710.21</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">578.27*773.13+8.64</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">773.13</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">*875.48*173.78+29.37*49.58</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">875.48</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">817.36*261.29+10.48*31.17</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">261.29</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">-554.07*70.2-96.58*14.28*15.19</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">70.2</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">402.93*203.66+79.32*4.45+99.23</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">203.66</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">2+951.89-12</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">0</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">831.12*360.68-33.26</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">360.68</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">412.65*251.21+92.61*48.19/39.96*26.49</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">251.21</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">176.12+107.43*5.23*6</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">6</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">865.91*517.23-81.15*74.19*44.39*12.23</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">517.23</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" width="451" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">583.78*632.14-100</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">632.14</td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl28" width="451" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 338pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #99ccff;">587.01*68.8/70.78*8.54</td><td class="xl26" width="72" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffcc;">68.8</td></tr></tbody></table><table cellspacing="0" cellpadding="0" width="451" border="0" xstr="" style="WIDTH: 338pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="451" style="WIDTH: 338pt; mso-width-source: userset; mso-width-alt: 14432;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="451" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;">题目要求：提出左面字符串中"*"数据最大的一个。</div></td></tr><tr height="38" style="HEIGHT: 28.5pt;"><td class="xl24" width="451" height="38" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 28.5pt; BACKGROUND-COLOR: #99ccff;">          如A1：26.74，90.9，28.22  最大的就是90.9</td></tr><tr height="38" style="HEIGHT: 28.5pt;"><td class="xl25" width="451" height="38" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 28.5pt; BACKGROUND-COLOR: #99ccff;">不可以用辅助单元格，不可以用定义名称，不可用VBA</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="451" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">跟贴写出公式就可以，好公式给予奖励</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="451" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">说明：1.最大数不会大于999.99</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="451" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">      2.左面的字符串中没有"*"结果返回0</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl24" width="451" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">      3.字符最多是小数点后两位 <div></div></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl26" width="451" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 338pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #99ccff;">看过上贴的这个就很简单了，注意区别</td></tr></tbody></table>

willin2000 · 发表于 2008-5-20 14:32

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

willin2000 · 发表于 2008-5-20 15:10

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

hai · 发表于 2008-5-20 16:21

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

还是这个公式!

knifefox · 发表于 2008-5-20 16:29

出题目的看看大家的text函数的功力，希望能看到更多的公式。

willin2000 · 发表于 2008-5-20 20:48

试试.

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

Luckyguy2008 · 发表于 2008-5-20 23:08

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

[此贴子已经被作者于2008-5-20 23:15:24编辑过]

knifefox · 发表于 2008-5-20 23:16

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用willin2000在2008-5-20 20:48:00的发言： 试试.</div>相当的精彩！赞一个！[em17]

knifefox · 发表于 2008-5-20 23:28

我也给一个，其实这个公式我上个帖子给了，当时给错了。我还说呢我记得要用两个text 怎么不用也行呢[em04]

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

xinanjiang · 发表于 2008-5-24 13:09

[em01]

		自动登录	找回密码
密码			注册

[通知] [练习题]返回指定字符后最大数字（2）