ä¸ç§æ¯å¥å 个ifå½æ°å°±å¯ä»¥ï¼è¿å¯ä»¥å©ç¨lookupå½æ°ï¼
=LOOKUP(A1,{0,3001,5001,10001},{0.005,0.01,0.15,0.002})
è¿éæ¯å¤çæ£æ´æ°åéï¼{0,3001,5001,10001}éç0å¯ä»¥æ¢æå
¶ä»æ°ï¼ä½è¦æ¯ä½ çåéçæå°å¼è¿è¦å°ã3001,5001,10001è¿éä¹æ以ä¸ç¨3000,5000,10000æ¯ä¸ºäºçäº3000,5000,10000æ¶ä¸ä¼åºéï¼ä½æ¯å¦æåééæå°æ°ï¼å¯ä»¥æ3001æ¢æ3000.0000001è¿æ ·çå°±å¯ä»¥ã
追é®ä¸æè§åï¼é¡ºå©è§£å³æçé®é¢ï¼è°¢è°¢ï¼é纳çæ¡ï¼