excel if函数如何实现多级嵌套答:$B$2,IF(Sheet1!A1<=75,Sheet2!$B$3,IF(Sheet1!A1<=100,Sheet2!$B$4,IF(Sheet1!A1<=125,Sheet2!$B$5,IF(Sheet1!A1<=150,Sheet2!$B$6,IF(Sheet1!A1<=175,Sheet2!$B$7,IF(Sheet1!A1<=200,Sheet2!$B$8,Sheet2!$B$9)))不过好像if函数嵌套层数是有限制的。
excel的if函数多个嵌套答:LOOKUP(A1,{0,50,150,250,350,450,550,650,750},{4.5,5.6,6.7,7.6,8.6,9.6,10.6,11.6})第一个数组前需加0,否则50以内的数无法判断