Problem with if <= formula not calculating correctly

It is difficult to debug from a picture/screenshot. A representative, anonymized sample file would be better.

That said, I notice that all of the values in column D have a little green triangle indicating some kind of error/warning associated with those cells/values. The first one I think of is "number stored as text". When it comes to "order", a text string is always "larger than" a number, so the text string "185.0" is larger than the number 186.5. The first thing I would do to debug this is to hover over the green triangle and see what error/warning is given. If it is "number stored as text", then the next step is to convert that column to real numbers (some strategies here: https://support.office.com/en-us/art...1-c5bad0f0a885 ).