使用if嵌套语句，公式如下：=if(B2>=10, 1, if(5<B2<10, 0.8, if(5<=B2,0,3, "NA")))返回“NA”表示这个数值不存在。
excel自带的if函数解释：IF function in Excel SYNTAX : IF(Something is True, then do this, otherwise do this)Example: =IF(A1 EXPLANATION : If the value in A1 is less than the value in B1, the value "OK" is returned, otherwise return a 0.
