Using logical command "IF"

[Daniel Caballero]

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 response to solve this issue is highly appreciated. Please see references below and the attachment. Thank you.

The following syntax is for cell "E58":

=IF(D58<=4.8,1,IF(4.8<D58<=9.6,2,IF(9.6<D58<=14.4,3,IF(14.4<D58<=19.2,4,IF(19.2<D58<=24,5,IF(24<D58<=28.8,6))))))

The following syntax is for cell "D58":

=((A58+B58)*0.09)+C58

[#2]

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