¿é¤J¬Û¦P½s¸¹®É, ¦Û°ÊÅã¥Ü¤W¤@µ§»ÈÃB
- ©«¤l
- 1360
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1370
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-4-19
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 1360
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1370
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-4-19
|
¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-8-29 19:04 ½s¿è
¦^´_ 6# clio
(¤@)¨Ò :LOOKUP(A1,{1,5,9},{"A","B","C"})-->A1=1~4-->"A" ,5~8-->"B" ,9(§t)¥H¤W-->"C"-->¥t¸Ñ 1(§t)¥H¤W¬OA ;5(§t)¥H¤W¬OB ;9(§t)¥H¤W¬OC ;<1 ¿ù»~
(¤G)±ø¥ó¦¨¥ß¬°¯u(TURE) ±ø¥ó¤£¦¨¥ß¬°°² (FALSE)-->LOOKUP(1,0/±ø¥ó¬O§_¦¨¥ß,¹ïÀ³¦C)-->0/TURE©ÎFALSE-->0»PµL·N¸q-->LOOKUP§ä¨ì³Ì«á¤@Ó¬°¯u .¬°0 ªÌ
¨Ò :A1:A5={1,2,3,4,5}-->LOOKUP(1,0/(A1:A5<3),{11,12,13,14,15})-->0/(A1:A5<3)²£¥Í{0,0,µL·N¸q,µL·N¸q,µL·N¸q}-->§ä¨ì³Ì«á¤@Ó¬°¯u .¬°0 ¬O²Ä¤G¦ì¸mªº¹ïÀ³¦C 12 |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 1360
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1370
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-4-19
|
¦^´_ 8# clio
INDEX(D$1:D3,MATCH(,0/(B$1:B3=B4),))
OR
INDEX(D:D,MATCH(,0/(B$1:B3=B4),)) |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|