Here's one way of doing it:

=1.69 + INT((MONTH(F1)-1)/3)*0.1

but not the easiest to maintain !! <bg

Hope this helps.

Pete


"southwindmarine" wrote in
message ...
What I'm trying to do is input a date into say cell F1, then depending on
the
date I want that to generate a price in F3.

The information is:
If date is on or between
1/1/2008-4/30/2008 = 1.69
5/1/2008-6/30/2008 = 1.79
7/1/2008-8/31/2008 = 1.89
9/1/2008-12/31/2008 = 1.99

How do I set this up? I've tried many different formulas and functions but
none are returning the results I want.