<p><font face="黑体" color="#421ae6" size="4">趣味题(可做为水平测试参考题),我不提示,大家自己看看找出规律,再写公式.</font></p><p>顶贴的热情不高,我贴出3种答案好了:</p><p>=IF(ISERR(FIND(0,A1&SUM(-(0&MID(A1,COLUMN(1:1),1))))),TEXT(A1,REPT(REPT("!*",RIGHT(A1))&0,LEN(A1)))&REPT("*",RIGHT(A1)),A1)</p><p>=IF(COUNT(FIND(0,A1&SUM(-(0&MID(A1,COLUMN(1:1),1))))),A1,TEXT(A1,REPT(REPT("!*",RIGHT(A1))&0,LEN(A1)))&REPT("*",RIGHT(A1)))</p><p>=SUBSTITUTE(TEXT(A1,"-"&REPT("0-",LEN(A1))),"-",IF(COUNT(FIND(0,A1&SUM(-(0&MID(A1,COLUMN(1:1),1))))),,REPT("*",RIGHT(A1))))</p><p></p><br/>
[此贴子已经被作者于2008-9-16 0:28:32编辑过] |