Forum Discussion

Daniel Caballero's avatar
Daniel Caballero
Copper Contributor
Aug 14, 2018

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 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

 

Excel Desktop
Need Help
Requests
training

1 Reply

  • Philip West's avatar
    Philip West
    Iron Contributor
    Aug 14, 2018

    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

Resources