Question

求一个Excel一个公式

求一个Excel一个公式如下图的一个公司

Answer 1

=IF(A1="","",LOOKUP(A1,{0,40,50,55,60,65,70},{0.5,0.55,0.65,0.7,0.8,1}))

Answer 2

使用下列公式之一
=IF(A1="","",LOOKUP(A1,{0,0.5;40,0.55;50,0.65;55,0.7;60,0.8;70,1}))

=IF(A1="","",LOOKUP(A1,{0,40,50,55,60,70},{0.5,0.55,0.65,0.7,0.8,1}))

Answer 3

=IF(A1<40,0.5,IF(A1<50,0.55,IF(A1<55,0.65,IF(A1<60,0.7,IF(A1<65,0.8,1)))))