I am trying to have excel return a certain value based on a series of
date ranges.

I want the value to return true or a specific number if it returns a
number less than the max, but if greater than a max number for the
period I want it to return only the max number.

An example:

01/01/2008-12/31/2008=3000,

01/01/2009-12/31/2009=3600.

So lets say the persons salary or wage for 2008 was 2888.00, then I
would want the formula to return 2888.00.

But if the salary for 2008 was 3700.00 I would want the value to
return 3000.

Can anyone suggest anything?

Thanks in advance