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

¨Ì¼Æ¦r¥h´M§ä¹ï·Óªí,±a¥X¯Å¶Z¸ê®Æ

¨Ì¼Æ¦r¥h´M§ä¹ï·Óªí,±a¥X¯Å¶Z¸ê®Æ

BÄ椽¦¡³]©w¡G
¨ÌAÄæ¼Æ¦r¥h¹ï·ÓDÄæ¡A±NDÄ檺¸ê®Æ±a¤JBÄæ

¬¡­¶Ã¯10.zip (6.62 KB)

joyce

=LOOKUP(A2,{0,101,201,301,401,501},D$2:D$7)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# hcm19522


    ÁÂÁ¸ѵª
joyce

TOP

101~199 ¨º200Âk­þ¸Ì
201~299 ¨º300Âk­þ¸Ì
301~399 ¨º400Âk­þ¸Ì
401~499
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089


    §ó¥¿¯Å¶Zªí¡G
¯Å¶Zªí
99¥H¤U
100~199
200~299
300~399
400~499
500¥H¤W

ÁÂÁ´£¿ô
joyce

TOP

¦^´_ 6# leiru


    =LOOKUP(A2,{0;1;2;3;4;5}*100,D$2:D$7)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


    ÁÂÁÂ
joyce

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD