I have a worksheet that uses decimals in one sheet, and looks up a value based on the decimal in a table.
However if it doesn't find the result, it shows rounded down result (the last row in the table), and I need it to show the rounded up result (the next row in the table).
Any ideas?