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

[µo°Ý] ­n¥Î¬Æ»ò¨ç¼Æ¤~¯àºâ¯Å¼Æ???

[µo°Ý] ­n¥Î¬Æ»ò¨ç¼Æ¤~¯àºâ¯Å¼Æ???

½d¨Ò¦p¤U

°Ýµª.jpg
2018-12-20 21:10

¦^´_ 3# hcm19522


    ¤j¤j§A¦n  ¦pªG¹J¨ì

-1  2000
-2   3500
-3  5000
-4  6000

¹J¨ì-ªº¯Å¶Z¥i¥H©ñ¦b¦P¤@­Ó¦ì¸m?

TOP

E2:E7 (¯Å¼Æ¤À¼Æ¤£µ¥®t)=IF(D2>=A$7,B$7,VLOOKUP(D2,A$2:B$7,2,1)+SUMPRODUCT(OFFSET(B$1,MATCH(D2,A$2:A$7),,2)*{-1;1})*MOD(D2,1))
5230.png
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# keovin790916
¦p½d¨Ò¹Ï¥Ü¡A°²³]¤p¶Àªº1.3­È¦ì©óÀx¦s®æF3¡AÀx¦s®æ¢Õ3¤½¦¡¿é¤J
=(INT(F3)*2-1+MOD(F3,1)*INT(F3))*1000
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD