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