If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
If Statement for a date
=IF(A6DATEVALUE("5/11/2009"),0.324,0.335)
-- Gary''s Student - gsnu200857 |
#3
|
|||
|
|||
If Statement for a date
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" wrote in message ... 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. |
#4
|
|||
|
|||
If Statement for a date
Thank you!
"Bernard Liengme" wrote: 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" wrote in message ... 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. |
#5
|
|||
|
|||
If Statement for a date
Thank you!
"Gary''s Student" wrote: =IF(A6DATEVALUE("5/11/2009"),0.324,0.335) -- Gary''s Student - gsnu200857 |
Thread Tools | |
Display Modes | |
|
|