快递excel公式套用
重量要进一,怎么用公式算出费用呢,麻烦各位大佬帮帮忙
虽然看不清图片
但根据经验,这样的问题都是通过lookup()函数解决的
范例:
=LOOKUP(F3,{0,"F";50,"D";53,"C-";58,"C";63,"C+";68,"B-";72,"B";78,"B+";83,"A-";88,"A";93,"A+"})
热门标签:
重量要进一,怎么用公式算出费用呢,麻烦各位大佬帮帮忙
虽然看不清图片
但根据经验,这样的问题都是通过lookup()函数解决的
范例:
=LOOKUP(F3,{0,"F";50,"D";53,"C-";58,"C";63,"C+";68,"B-";72,"B";78,"B+";83,"A-";88,"A";93,"A+"})