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

[µo°Ý] ¨ç¼Æ¤½¦¡¤@°Ý

[µo°Ý] ¨ç¼Æ¤½¦¡¤@°Ý

¦U¦ì¤j¤j¦n
¤p§Ìªñ´Áª¦¤å¬Ý¨£¨Ï¥ÎExcel¦³¤@´«ºâ¹q¶O¤½¦¡¬°
=ROUND(SUMPRODUCT(TEXT(B2-{0,260,600},"0;!0")*{1.2,0.3,0.5}),)

¤p§Ì¦³¤@¨Æ¤£¸Ñ§Æ±æ¯à¸Ñ´b
¤W­z¤§¤½¦¡
¨ä¤¤{0,260,600} ¤Î{1.2,0.3,0.5}

½Ð°Ý³o¤j¨í©·¥Î·N¬°¦ó©Î¥Îªk¬°¦ó
ºô¸ô¤W¹M´M¤£¨ì³o¥Îªk
¥t¥~TEXT  ,"0;!0" ¤wª¾¨D ¥¿¼Æ
ÁÙ¦³¨ä¥¦¬ÛÃöTEXTªº¥Îªk¶Ü? Office¤ä´©¤¤¤ß°£¥~

ÁÂÁÂ

¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-6 12:34 ½s¿è

¦^´_ 1# fantersy
´å¼Ð°±©ó±a¦³¸Ó¤½¦¡ªºÀx¦s®æ¤W¡A°õ¦æ¡u¤½¦¡¡v¡÷¡u¤½¦¡½]®Ö¡v¡÷¡uµû¦ô­È¤½¦¡¡v¡A§Y¥i©úÁA¤½¦¡¹Bºâ¹Lµ{¡C
¨Ò¦pÀx¦s®æB2­È¬°100
TEXT(B2-{0,260,600},"0;!0")*{1.2,0.3,0.5}
¡÷TEXT(100-{0,260,600},"0;!0")*{1.2,0.3,0.5}
¡÷TEXT({100,-160,-500},"0;!0")*{1.2,0.3,0.5}
¡÷{"100","0","0"}*{1.2,0.3,0.5}
¡÷{120,0,0}
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212
·PÁÂp212¸Ô²Óªº»¡©ú!!
{ } §Ú¤@ª½¥H¬°¬O¦b°}¦C¤½¦¡¤W¤~¥Îªº¨ì
TEXT¤½¦¡¤º¨Ï¥Î{ }¤]¬O°}¦Cªº·N«ä¶Ü?

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-7 08:36 ½s¿è

¦^´_ 3# fantersy
Yes¡I
³o¯ë°}¦C¬O¤£»Ý­n¥HCtrl+Shift+Enter±Ò°Êªº

TOP

¦^´_ 4# p212


    ¯uªº¤Ó·PÁÂp212¤j¤j¤F^^

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD