If Statement for a date

[jlo]

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.

 

[Gary''s Student]

=IF(A6<DATEVALUE("5/11/2009"),0.324,0.335)

 

[jlo]

Thank you!

This will return the rate based on your example
=IF(A6>=DATE(2009,5,11),0.335,0.324)

We could do the multiplication with
=IF(A6>=DATE(2009,5,11),0.335,0.324)*B6
where B6 is the cell with Total

Another way would be = B6*(0.324 + 0.011*(A6>=DATE(2009,5,11))
Note that 0.011 is the increase in the rate after May 11.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

 

[jlo]

Thank you!