²é¿´: 287  |  »Ø¸´: 5
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£
¡¾ÐüÉͽð±Ò¡¿»Ø´ð±¾ÌûÎÊÌ⣬×÷Õßchenxing868½«ÔùËÍÄú 3 ¸ö½ð±Ò
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

chenxing868

½ð³æ (СÓÐÃûÆø)

[ÇóÖú] ¹ØÓÚexcleÂß¼­º¯Êý

´ó¼ÒºÃ£¡ÎÒÏëÔÚexcleÖбàдÕâÑùÒ»¸öº¯Êý£¬ÊǶÔD10µ¥Ôª¸ñ½øÐÐÅжϣ¬µ±ÊäÈëAʱÔÚµÄD11Öдò3·Ö£¬ÊäÈëBʱ£¬´ò2·Ö£¬ÊäÈëCʱ´ò1·Ö£¬Îұ༭µÄº¯ÊýÊÇÕâÑùµÄ£º
=IF(D10="A",3,IF(D10="B",2,IF(D10="C",1)))£¬µ±ÊäÈëAºÍBʱ¶¼Äܰ´ÕÕº¯ÊýÕýÈ·µÄ´ò·Ö£¬´òÊäÈëCʱ¾Í³öÏÖFALSE£¬Çë¸ßÊÖ¸øÓè½â¾öлл

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

kaiyuxing

½ð³æ (ÕýʽдÊÖ)

Сľ³æÖ®»ªÖеØÇøÀíʳ¤

¡ï
chenxing868(½ð±Ò+1,VIP+0):лл 2-4 13:49
ÓÃÕâÖÖ·½·¨Ã»ÓÐÎÊÌ⣬ÀýÈçÔÚD11ÖÐÊäÈë=IF(D10="A",3,IF(D10="B",2,IF(D10="C",1)))£¬¼´¿ÉÍê³ÉÅжϣ¬ÔÚ D10ÖÐÊäÈëCʱ´ò·ÖΪ1¡£
Ç뿼ÂÇÂ¥ÉϵÄÌáʾ£¬Èô²»ÊÇÉÏÊöÎÊÌâÇ뿼ÂÇʹÓþø¶ÔÒýÓ㬼´½«
=IF(D10="A",3,IF(D10="B",2,IF(D10="C",1)))
¸ÄΪ
=IF($D$10="A",3,IF($D$10="B",2,IF($D$10="C",1)))

[ Last edited by kaiyuxing on 2008-9-4 at 15:40 ]
¶ÍÁ¶ÉíÌ壬¿Ì¿à×êÑУ¡
3Â¥2008-09-04 15:37:46
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 6 ¸ö»Ø´ð

wwr_blue

ľ³æ (³õÈëÎÄ̳)

¡ï
chenxing868(½ð±Ò+1,VIP+0):ÅжÏÕýÈ· 2-4 13:49
ûÓÐÎÊÌâ°¡£¬ÖÁÉÙÎÒÕâ¶ùûÓÐÈκÎÎÊÌâ¡£
»á²»»áÄãCǰºó¶àÁ˿ոñÖ®ÀàµÄ·ûºÅ£¿
2Â¥2008-09-04 15:35:53
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÑîСÅÖ

½ð³æ (ÕýʽдÊÖ)

ÎÒÒ²ÊÔ¹ýÁË£¬ÎÒµÄҲûÎÊÌâ
ÈËÉúÖÐ×î»Ô»ÍµÄ²»Êǹ¦³ÉÃû¾ÍµÄʱºò£¬¶øÊÇÔÚʧ°ÜºÍ´ìÕÛÖп´µ½Ï£Íû²¢ÎªÖ®·Ü¶·µÄÈÕ×Ó
4Â¥2008-09-04 15:55:29
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

chenxing868

½ð³æ (СÓÐÃûÆø)

лл£¬¸ã¶¨£¬¹«Ê½Ã»ÓÐÎÊÌ⣬ÊÇÎÒÔÚÊäÈëD10µÄÅÐÀàʱ³ö´íÁË£¬ÔÚcºóÓÐÒÔ¿Õ¸ñ
5Â¥2008-09-04 16:09:22
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²»Ó¦Öú È·¶¨»ØÌûÓ¦Öú (×¢Ò⣺ӦÖú²Å¿ÉÄܱ»½±Àø£¬µ«²»ÔÊÐí¹àË®£¬±ØÐëÌîд15¸ö×Ö·ûÒÔÉÏ)
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 346Çóµ÷¼Á[0856] +4 WayneLim327 2026-03-16 7/350 2026-03-21 04:02 by JourneyLucky
[¿¼ÑÐ] 265Çóµ÷¼Á +3 Jack?k?y 2026-03-17 3/150 2026-03-21 03:17 by JourneyLucky
[¿¼ÑÐ] 317Çóµ÷¼Á +8 Éê×ÓÉêÉê 2026-03-19 13/650 2026-03-21 00:09 by Áõ¹úÉ­
[¿¼ÑÐ] 274Çóµ÷¼Á +10 S.H1 2026-03-18 10/500 2026-03-20 23:51 by JourneyLucky
[¿¼ÑÐ] 321Çóµ÷¼Á +9 ºÎÈó²É123 2026-03-18 11/550 2026-03-20 23:19 by JourneyLucky
[¿¼ÑÐ] ÖÐÄÏ´óѧ»¯Ñ§Ñ§Ë¶337Çóµ÷¼Á +3 niko- 2026-03-19 6/300 2026-03-20 21:58 by luoyongfeng
[»ù½ðÉêÇë] ѧУÒѾ­Ìá½»µ½NSFC£¬»¹ÄÜÐÞ¸ÄÂ𣿠40+4 babangida 2026-03-19 8/400 2026-03-20 15:58 by babero
[¿¼ÑÐ] 298-Ò»Ö¾Ô¸Öйúũҵ´óѧ-Çóµ÷¼Á +9 ÊÖ»úÓû§ 2026-03-17 9/450 2026-03-20 14:24 by ÎÞи¿É»÷111
[¿¼ÑÐ] 081700»¯¹¤Ñ§Ë¶µ÷¼Á +3 ¡¾1¡¿ 2026-03-16 3/150 2026-03-19 23:40 by edmund7
[¿¼ÑÐ] Áº³ÉΰÀÏʦ¿ÎÌâ×é»¶Ó­ÄãµÄ¼ÓÈë +9 һѼѼӴ 2026-03-14 11/550 2026-03-19 17:22 by £¡±¾°µÒ»´Î£¡
[¿¼ÑÐ] ±¾¿ÆÖ£ÖÝ´óѧÎïÀíѧԺ£¬Ò»Ö¾Ô¸»ª¿Æ070200ѧ˶£¬346Çóµ÷¼Á +4 ÎÒ²»ÊÇÒ»¸ù´Ð 2026-03-18 4/200 2026-03-19 09:11 by ¸¡ÔÆ166
[¿¼ÑÐ] 344Çóµ÷¼Á +6 knight344 2026-03-16 7/350 2026-03-18 20:13 by walc
[¿¼ÑÐ] 334Çóµ÷¼Á +3 Ö¾´æ¸ßÔ¶ÒâÔÚ»úÐ 2026-03-16 3/150 2026-03-18 08:34 by lm4875102
[¿¼²©] 26²©Ê¿ÉêÇë +3 1042136743 2026-03-17 3/150 2026-03-17 23:30 by ÇáËɲ»ÉÙËæ
[¿¼ÑÐ] 308Çóµ÷¼Á +4 ÊÇLupa°¡ 2026-03-16 4/200 2026-03-17 17:12 by ruiyingmiao
[¿¼ÑÐ] 290Çóµ÷¼Á +3 p asserby. 2026-03-15 4/200 2026-03-17 16:35 by wangkm
[¿¼ÑÐ] Ò»Ö¾Ô¸£¬¸£ÖÝ´óѧ²ÄÁÏר˶339·ÖÇóµ÷¼Á +3 ľ×ÓmomoÇàÕù 2026-03-15 3/150 2026-03-17 07:52 by laoshidan
[¿¼ÑÐ] 283Çóµ÷¼Á +3 Ìý·ç¾ÍÊÇÓꣻ 2026-03-16 3/150 2026-03-17 07:41 by ÈÈÇéɳĮ
[¿¼ÑÐ] 26¿¼ÑÐÒ»Ö¾Ô¸ÖйúʯÓÍ´óѧ(»ª¶«)305·ÖÇóµ÷¼Á +3 ¼ÎÄêÐÂ³Ì 2026-03-15 3/150 2026-03-15 13:58 by ¹þ¹þ¹þ¹þºÙºÙºÙ
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á +3 ºôºô£¿~+123456 2026-03-14 3/150 2026-03-14 16:53 by WTUChen
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û