ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó§Q¥Î¨ç¼Æ¦Û°Ê±a¥X¼Æ¦r°Ï¶¡¤º©Ò¥Nªíªº¥t¤@²Õ¼Æ¦r

[µo°Ý] ¦p¦ó§Q¥Î¨ç¼Æ¦Û°Ê±a¥X¼Æ¦r°Ï¶¡¤º©Ò¥Nªíªº¥t¤@²Õ¼Æ¦r

¦p¦ó§Q¥Î¨ç¼Æ¦Û°Ê±a¥X¼Æ¦r°Ï¶¡¤º©Ò¥Nªíªº¥t¤@²Õ¼Æ¦r
½Ð°Ñ¸Ôªþ¥ó

TEST.rar (1.78 KB)

¦^´_ 1# pupai
=IF($D$5<=1.99%,$B$9,IF($D$5<=3.99%,$B$10,IF($D$5<=5.99%,B11,IF($D$5<=7.99%,$B$12,IF($D$5<=9.99%,$B$13,$B$14)))))

TOP

=HLOOKUP(D5,{0,0.02,0.04,0.06,0.08,0.1;0.125,0.15,0.175,0.2,0.225,0.25},2,1)

TOP

¦^´_  pupai
=IF($D$5
GBKEE µoªí©ó 2010-10-11 15:25



ª©¥D¦n
°ÝÃD¸Ñ¨M¤F
ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD