怎样用公式，对Excel表格的两个单元格的值，进行判断
发布网友
共2个回答
热心网友
C2单元格输入
=IF(B4=1,0.3,IF(B4=0,LOOKUP(B3,{0,10,20},{0.1,0.2,0.3})))
热心网友
C2输入
=if(b4=1,0.3,if(b3<10,0.1,if(b3<20,0.2,if(b3>=30,0.3,""))))
