OK, did you try what I suggested?The value I would want to round down would be in D5 compared to the constants in column A.
The value I picked for this demo (D5) is exactly in the middle of A4 & A5. I could have round up and chose A4 but for my purposes, the value I would rather have is more a conservative approach which would make me want to round down & have A5 highlighted.
=ABS(ROUNDDOWN(A1,0)-$D$5)
=B1=MIN(B$1:B$21)