如题所述
=IF(D5=601,Sheet2!B12,IF(D5=2,Sheet2!B11,IF(D5=3,Sheet2!B10,IF(D5=4,Sheet2!B9,IF(D5=5,Sheet2!B8,IF(D5=6,Sheet2!B7,IF(D5=501,3000,IF(D5=502,Sheet2!B4,if(D5=505,B46)))))))))我写到这样就出错误了。。。