写了很久,有一半结果是false。求指点。自己半吊子,打了半天,不知道哪儿错了。
=IF(AND(OR(O3={"彩钢板房","土建","租赁机房"}),M3="转供"),"1.7*1.2",IF(AND(OR(O3={"彩钢板房","土建","租赁机房"}),M3="直供"),"1.7",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="直供",OR(L3={"0","1","2"})),"1.4",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="直供",L3="无"),"1.1",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="转供",OR(L3={"0","1","2"})),"1.4*1.2",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="转供",L3="无"),"1.1*1.2"))))))
=IF(AND(OR(O3={"彩钢板房","土建","租赁机房"}),M3="转供"),"1.7*1.2",IF(AND(OR(O3={"彩钢板房","土建","租赁机房"}),M3="直供"),"1.7",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="直供",OR(L3={"0","1","2"})),"1.4",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="直供",L3="无"),"1.1",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="转供",OR(L3={"0","1","2"})),"1.4*1.2",IF(AND(OR(O3={"一体化机柜","一体化机房"}),M3="转供",L3="无"),"1.1*1.2"))))))