Óû§Ãû£º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¡£