NUMBERS: Lookup hourly rental rate based on date of transaction
Ok, so now had chance to test, use this formula :

=IF(C2&lt;=A4,B4,IF(C2&lt;=A3,B3,IF(C2&lt;=A2,B2)))


The date tested is in cell C2 and the three dates are in A2, A3 and A4, while the three rates are in B2, B3 and B4.

The logic has been reversed ie test for the oldest date first.

You could also use names for the 3 rates, but it will work the same.