View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jlo jlo is offline
external usenet poster
 
Posts: 16
Default If Statement for a date

In cell A6 a date is entered. In another cell is a total number of items.
To get a total price for the items, I take Total Number of items and multiple
by the rate (0.335). The problem with that is the rate will increase
periodically from a specific date.

Is there an if statement or formula that will use A6 (date will be keyed in
the cell). Example the current rate for items is 0.335 on May 11, 2009 and
after. However any date previous to May 11, 2009 rate would be 0.324.

Thanks in advance.