Forum Discussion
Using logical command "IF"
Program is EXCEL2013. There were six (6) "IF" commands in array but it reads the first logical test only to give a correct answer and it gives false statement on the other tests. Your appropriate re...
I think your formula is wrong. I think you are trying to write this:
=IF(D58<=4.8,1,IF(D58<=9.6,2,IF(D58<=14.4,3,IF(D58<=19.2,4,IF(D58<=24,5,IF(D58<=28.8,6))))))
With this is should be False if you get above 28.8