excel ¹«Ê½ ifº¯Êý

ʱ¼ä£º2016.06.03 ·¢²¼ÈË£ºai4867425

excel ¹«Ê½ ifº¯Êý

Òѽâ¾öÎÊÌâ

¹È¸èai4867425Óû§ÔÚ2016.06.03Ìá½»Á˹ØÓÚ¡°½õÐåδÑëexcel ¹«Ê½ ifº¯Êý¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-03-03T03:49:13¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬ÄãÊÇÎҵı¦±´,ÄãÊÇÎҵύ,ллÄã¶ÔÎҵİïÖú£¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºtehongpvi  

¸ù¾ÝÒÑÖªÌõ¼þ£¬ÉèÖú¯ÊýµÄ·½·¨¼°²½ÖèÊÇ£º

·½·¨Ò»£º

1¡¢´ò¿ªExcel¹¤×÷±í£»

2¡¢¸ù¾ÝÏÂÊöÒÑÖªÌõ¼þ£º

¼ÙÉèA1µ¥Ôª¸ñΪÊýÖµ£¬ÏëÔÚA2µ¥Ôª¸ñµÃ³öÈçϽá¹û
Èç¹ûA1<5£¬A1+2
(A1<10£¬A1>=5)£¬A1+3
(A1<15£¬A1>=10)£¬A1+4
(A1<20£¬A1>=Ëæ½ôÄï¹¥ÀîºÚÅà¾Í15)£¬A1+5
(A1<25£¬A1>=20)£¬A1+6

¿ÉÒÔͨ¹ýIFº¯Êý½¨À´×ÔÁ¢Ò»¸öǶÌ×Ìõ¼þº¯Êý£»

3¡¢ÔÚA2µ¥Ôª¸ñÊäÈëÒÔϹ«Ê½

=A1+IF(A1<5,2,IF(A1<10,3,Iɱ³ÂռѹʱάF(A1<15,4,IF(A1<20,5,6))))

¹«Ê½±íʾ£ºA1¼ÓÉϸù¾ÝA1Ìõ¼þµÄ²»Í¬¶ø·µ»ØµÄ²»µÐ½âÒøºâÊÓͬµÄÊýÖµ¡£

·½·¨¶þ£º

1¡¢´ò¿ªExcel¹¤×÷±í£»

2¡¢¸ù¾ÝÒÑÖªÌõ¼þ£¬ÅжÏÌõ¼þ¹æÂÉ£¬ÊÇÔÚÒ»¸öÉýÐòµÄÊýÁÐÖУ¬·µ»Ø¶ÔÓ¦µÄÊýÖµ£»¿ÉÒÔ½«Õâ×éÉýÐòÊýÖµÕûÀíµ½Ò»¸öÇøÓò£¬Ò²¿ÉÒÔÖ±½ÓÔÚ¹«Ê½ÖÐÂÞÁУ¬Í¨¹ýLOOKUPº¯Êý·µ»ØÉýÐòÊýÁÐÖÐСÓÚÌõ¼þµÄ×î´óÖµËù¶ÔÓ¦µÄÊýÖµ¡£

3¡¢ÔÚA2331215ÎÊ´ðµ¥Ôª¸ñÊäÈë

=A1+L³¬OOKUP(A1,D:E)

¹«Ê½±íʾ£ºÔÚÉýÐòÊýÁÐDÁÐÖУ¬²éÕÒ±ÈA1ÊýֵСµÄ×î´óÖµ£¬²¢·µ»ØÆä¶ÔÓ¦µÄEÁеÄÊýÖµ£¬È»ºó¼ÓÉÏA1

»òÕßÊäÈë=A1+LOOK¶Ë»ùUP(A1,{0,¼þ¶½ÖªÀ­×ïÅÐʤµ¥5,10,15,20},{2,3,4,5,°ï»®Ç×¼û±¸Õ÷6})

·½·¨Èý£º

1¡¢´ò¿ªExcel¹¤×÷±í£»

2¡¢¸ù¾ÝÒÑÖªÌõ¼þÅжϣ¬·µ»ØÖµÓë5µÄ±¶ÊýÓйØÏµ£¬¿ÉÒÔ½¨Á¢Óë5µÄ±¶ÊýµÄ¹ØÏµÊ½¡£

3¡¢ÔÚA2µ¥Ôª¸ñÊäÈë

=A1+2+INT(A1/5)

¹«Ê½°ïÖ¯´Îͳºñ¹¹Õ÷ÂÌÎÈ×¼±íʾ£ºA1µ¥Ôª¸ñÊýÖ**ýÒÔ5µÄÕûÍ£ÑùÕ¼Ä©Ö¾ÐøÖ¹»¤Êý£¬¼ÓÉÏA1£¬ÔÙ¼ÓÉÏ2¡£