I'm transposing a formula from NUMBERS into an excel sheet and I'm having an issue with one cell. I have two cells, one looking for the closest number greater than a given number and another looking for the closest number less than the same number from the same list. The problem seems to be that the two formulas need the list sorted in opposite ways. I've attached a link to my spreadsheet, the cells in question are P and R. P is functioning correctly, R is not.
Spreadsheet
I think an array formula may be the answer but I'm not sure what to do.