Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement for a date
=IF(A6<DATEVALUE("5/11/2009"),0.324,0.335)
-- Gary''s Student - gsnu200857 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement for a date
Thank you!
"Gary''s Student" wrote: =IF(A6<DATEVALUE("5/11/2009"),0.324,0.335) -- Gary''s Student - gsnu200857 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if statement with date | Excel Worksheet Functions | |||
Date Between IF And Statement | Excel Discussion (Misc queries) | |||
How can I use a date in an IF/AND statement? | Excel Discussion (Misc queries) | |||
If statement with date | Excel Discussion (Misc queries) | |||
Date in an IF statement | Excel Worksheet Functions |