execl中if函数=IF(6<=(DATEDIF(N87,O87,"m"))<12,D87,"-")这个公式我想表示数值区间的时候,取不出数来。=IF(DATEDIF(N87,O87,"m")<12,D87,"-") 这样的话就可以。
=IF(6<=(DATEDIF(N87,O87,"m"))<12,D87,"-")
意思就是希望当 6<=(DATEDIF(N87,O87,"m"))<12时,单元格显示D87的内容,否则显示"-",但可惜IF()函数不认识6<=(DATEDIF(N87,O87,"m"))<12;它只能判别一个比较内容,所以可以改为:
=IF(6<=DATEDIF(N87,O87,"m"),IF(DATEDIF(N87,O87,"m")<12,D87,"-"),"-")
该函数的意思是当DATEDIF(N87,O87,"m")小于6时,显示"-",而DATEDIF(N87,O87,"m")大于6时,再由IF(DATEDIF(N87,O87,"m")<12,D87,"-")判断,小于12,显示D87内容,否则显示"-";
此可以达到要求。
。