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.