当excel表格中大于等于某个数值或小于等于某个数值时，要显示我所要的固定数值，如何设定公式的条件

问题描述

精选答案

使用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=

"

" this)=

"

" example:=

"IF(A1

" explanation=

"

" the=

"

" value=

"

" a1=

"

" less=

"

" than=

"

" b1,=

"

"

"ok

"=

"

" returned,=

"

" return=

"

" a=

"

" 0.=

"

">

其他回答

透视考研

使用if嵌套语句，公式如下：=if(B2>=10, 1, if(5<B2<10, 0.8, if(5<=B2,0,3,

"NA

")))返回“NA”表示这个数值不存在。

excel自带的if函数解释：IF function in ExcelSYNTAX :  IF(Something is True, then do this, otherwise do this)Example: =IF(A1EXPLANATION : If the value in A1 is less than the value in B1, the value

"OK

" is returned, otherwise return a 0.