=ROUND((VLOOKUP(D4363,配合比统计!$A$1:$G$9,3,FALSE)-0)*(1+J4363⼀100),0)

在查找到C30 C30(水下) C40(细石)时查找后显示错误,求指点
2025-05-07 10:14:00
推荐回答(1个)
回答1:

要么是
=ROUND(VLOOKUP(D4363,配合比统计!$A$1:$G$9,3,0)*(1+J4363/100),0)
要么是
=ROUND((VLOOKUP(D4363,配合比统计!$A$1:$G$9,3,FALSE)-0)*(1+J4363/100)