在EXCEL中显示一个范围数值的条件函数怎么出来,求大神告知!!!
=IF(LEFT(B5,1)="A",IF(AND(C5>=49,C5<=64),"非研发炉台","研发炉台"),IF(AND(C5>=49,C5<=64),"非研发炉台...
=IF(LEFT(B5,1)="A",IF(AND(C5>=49,C5<=64),"非研发炉台","研发炉台"),IF(AND(C5>=49,C5<=64),"非研发炉台","研发炉台"))选择A/B系列49到64的为研发炉台,公式不对,哪错了?怎么出来,求大神告知!!!
展开
4个回答
展开全部
更多追问追答
追答
将公式换成=IF(AND(VALUE(C5)>=49,VALUE(C5)<=64),"研发炉台","非研发炉台")
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询