excel的if函数怎么写两个值之间的

=IF(0<A1,IF(A1<15,A1,""),"") 可以这样修改一下就好了 =IF(A1>0,IF(A1<15,A1,""),"") =if(and(a1>0,a1<15),a1,"") =if(and(A1>0,A1<15),A1,"")