EXCEL中if函数怎么用 ,如果A1表内大于等于100 B1表格就等于529 如果A1...答:; 如果A1表内大于200小于等于300 B1就等于399 ; 如果A1表内大于300小于等于400 B1就等于499 这样吧??如果这样,公式接着:=if(A1<=100,529,if(A1<=200,299,if(A1<=300,399,if(A1<=400,499,"")))或者 =if(A1>=400,"",choose(roundup(a1/100,0),529,299,399,499))...