如果有多个值,只取一个值的话还是用if来的好,因为刷新公式可以直接出结果。
所有取值列通用刷新公式:
if(Number([参数_1])+Number([参数_2])+Number([参数_3])=Number(ColName(2)),Concat([参数_1]," ",[参数_2]," ",[参数_3]),
if(Number([参数_1])+Number([参数_2])+Number([参数_4])=Number(ColName(2)),Concat([参数_1]," ",[参数_2]," ",[参数_4]),
if(Number([参数_1])+Number([参数_2])+Number([参数_5])=Number(ColName(2)),Concat([参数_1]," ",[参数_2]," ",[参数_5]),
if(Number([参数_1])+Number([参数_2])+Number([参数_6])=Number(ColName(2)),Concat([参数_1]," ",[参数_2]," ",[参数_6]),
if(Number([参数_1])+Number([参数_3])+Number([参数_4])=Number(ColName(2)),Concat([参数_1]," ",[参数_4]," ",[参数_4]),
if(Number([参数_1])+Number([参数_3])+Number([参数_5])=Number(ColName(2)),Concat([参数_1]," ",[参数_3]," ",[参数_5]),
if(Number([参数_1])+Number([参数_3])+Number([参数_6])=Number(ColName(2)),Concat([参数_1]," ",[参数_3]," ",[参数_6]),
if(Number([参数_1])+Number([参数_4])+Number([参数_5])=Number(ColName(2)),Concat([参数_1]," ",[参数_4]," ",[参数_5]),
if(Number([参数_1])+Number([参数_4])+Number([参数_6])=Number(ColName(2)),Concat([参数_1]," ",[参数_4]," ",[参数_6]),
if(Number([参数_1])+Number([参数_5])+Number([参数_6])=Number(ColName(2)),Concat([参数_1]," ",[参数_5]," ",[参数_6]),
if(Number([参数_2])+Number([参数_3])+Number([参数_4])=Number(ColName(2)),Concat([参数_2]," ",[参数_3]," ",[参数_4]),
if(Number([参数_2])+Number([参数_3])+Number([参数_5])=Number(ColName(2)),Concat([参数_2]," ",[参数_3]," ",[参数_5]),
if(Number([参数_2])+Number([参数_3])+Number([参数_6])=Number(ColName(2)),Concat([参数_2]," ",[参数_3]," ",[参数_6]),
if(Number([参数_2])+Number([参数_4])+Number([参数_5])=Number(ColName(2)),Concat([参数_2]," ",[参数_4]," ",[参数_5]),
if(Number([参数_2])+Number([参数_4])+Number([参数_6])=Number(ColName(2)),Concat([参数_2]," ",[参数_4]," ",[参数_6]),
if(Number([参数_2])+Number([参数_5])+Number([参数_6])=Number(ColName(2)),Concat([参数_2]," ",[参数_5]," ",[参数_6]),
if(Number([参数_3])+Number([参数_4])+Number([参数_5])=Number(ColName(2)),Concat([参数_3]," ",[参数_4]," ",[参数_5]),
if(Number([参数_3])+Number([参数_4])+Number([参数_6])=Number(ColName(2)),Concat([参数_3]," ",[参数_4]," ",[参数_6]),
if(Number([参数_3])+Number([参数_5])+Number([参数_6])=Number(ColName(2)),Concat([参数_3]," ",[参数_5]," ",[参数_6]),
if(Number([参数_4])+Number([参数_5])+Number([参数_6])=Number(ColName(2)),Concat([参数_4]," ",[参数_5]," ",[参数_6]),
""))))))))))))))))))))