LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
if statement with date JJ Excel Worksheet Functions 2 April 9th 09 08:03 PM
Date Between IF And Statement Paperback Writer Excel Discussion (Misc queries) 6 July 29th 08 08:52 PM
How can I use a date in an IF/AND statement? gsmith Excel Discussion (Misc queries) 2 July 13th 05 12:27 AM
If statement with date Tanya Excel Discussion (Misc queries) 4 May 20th 05 01:42 AM
Date in an IF statement LyndieBee Excel Worksheet Functions 2 March 8th 05 04:11 PM


All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"