excel ¹«Ê½ ifº¯Êý

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

excel ¹«Ê½ ifº¯Êý

Òѽâ¾öÎÊÌâ

¹È¸èai4867425Óû§ÔÚ2016.06.03Ìá½»Á˹ØÓÚ¡°ÁúÖ®¹Èexcel ¹«Ê½ ifº¯Êý¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-09-02T20:57:17¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Ç§ÑÔÍòÓï,±í´ï²»ÁËÎҵĸм¤Ö®Çé,ÎÒÒÑÃú¼ÇÔÚÐÄ £¡

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

µÚ1¸ö»Ø´ð

Óû§Ãû£ºteÑóhongpvi  

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

·½·¨Ò»£º

1¡¢´ò¿ªExc·´ÑµºÃ¼äel¹¤×÷±í£»

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,IF(A1<15,4,IF(A1<20,5,6))))

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

·½·¨¶þ£º

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

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

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

=A1+LOOKUP(A1,D:E)

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

»òÕßÊäÈë=A1+LOOKUP(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¡£