ªð¦^¦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 : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD