中文字幕夫の上司に犯新沢平兰,jizz4国产热门精品水多,成人免费无码一区二区三区

excel根據(jù)2個單元的數(shù)據(jù)多少返回相應的值？

2022-12-12 02:53

根據(jù)2個單元的數(shù)據(jù)多少返回相應的值，不要用編程

2022-12-12 04:01

=CHOOSE(MIN(LOOKUP(B2,{0,5001,10001,20001,40001,80001},{1,2,3,4,5,6}),LOOKUP(C2,{0,10001,18001,36001,72001,1440****},{1,2,3,4,5,6})),0%,0.5%,1.2%,1.8%,3%,3.5%)

公式解釋：分別判斷B和C的范圍符合第幾項，然后用MIN選擇較小的那一項，再用CHOOSE來選擇第幾項對應的數(shù)值。

更多回答

2022-12-12 07:18

在D2中輸入或復制粘貼下列公式
=IFERROR(HLOOKUP(LOOKUP(B2,{1,5001,10001,20001,40001,80001;1,2,3,4,5,6})&LOOKUP(C2,{1,10001,18001,36001,72001,1440****;1,2,3,4,5,6}),{"11","22","33","44","55","66";0,0.005,0.012,0.018,0.03,0.035},2,),"無匹配數(shù)據(jù)")
下拉填充

熱門問答