excelif与条件怎么写( 二 )


=IF(B2<10,100,IF(B2<20,50,""))
所以整个公答式可写成
=IF(B2<2,200,IF(B2<10,100,IF(B2<20,50,"")))