我正在使用这个当前公式..
=IF((AND((IF(R2="Error",X2="Low")),AB2>=0,AB2<=5)),"Within","Exceed",IF(AND(IF(R2="Error",X2="Medium")),AB2>=0,AB2<=5),"Within","Exceed",IF(AND(IF(R2="Error",X2="High")),AB2>=0,AB2<=5),"Within","Exceed")))
并显示我输入了太多参数。
因为我的数据有很多条件......
Error & Low & Range = 0-5 days,
Error & Medium & Range = 0-3 days,
Error & High & Range = 0-3 days
Support & Low & Range = 0-7 days,
Support & Medium & Range = 0-5 days,
Support & High & Range = 0-3 days
如果在范围内则显示“在范围内”,如果不在范围内则显示“超出”
有什么办法可以解决这个问题吗?
答案1
你的公式应该这样写:
=IF(AND(R2="Error",X2="Low",AB2>=0,AB2<=5),"Within",IF(AND(R2="Error",X2="Medium",AB2>=0,AB2<=5),"Within",IF(AND(R2="Error",X2="High",AB2>=0,AB2<=5),"Within","Exceed")))
- 您可以根据需要调整公式中的单元格引用。
有关此问题的更多信息你可以检查一下。