| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
between dates
Hello,
I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnÂīt work! Please help as soon as possible! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
between dates
IF(AND(StartDate=OpeDate,OpeDate<=EndDate), 4.50%*Ammount,0)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "thanks" wrote in message ... Hello, I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnīt work! Please help as soon as possible! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
between dates
You want to use an AND in your formula...
IF(And(StartDate=OpeDate, OpeDate<=EndDate), 4.50%*Ammount,0) -- HTH... Jim Thomlinson "thanks" wrote: Hello, I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnÂīt work! Please help as soon as possible! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
between dates
Assume Op date is A2, Start date is C2, End date is D2 and Amount is
B2, then try this: =IF(AND(A2=C2,A2<=D2),B2*0.045,0) Hope this helps. Pete thanks wrote: Hello, I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnīt work! Please help as soon as possible! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
between dates
=IF(AND(StartDate=OpeDate,OpeDate<=EndDate),4.50% *Amount,0)
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "thanks" wrote in message ... Hello, I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnīt work! Please help as soon as possible! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
between dates
Try =IF(AND(StartDate<=OpeDate,OpeDate<=EndDate), 4.50%*Ammount,0)
-- David Biddulph "thanks" wrote in message ... Hello, I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnīt work! Please help as soon as possible! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
between dates
Thanks for your help! That worked perfectly!
"David Biddulph" wrote: Try =IF(AND(StartDate<=OpeDate,OpeDate<=EndDate), 4.50%*Ammount,0) -- David Biddulph "thanks" wrote in message ... Hello, I have the following information: Ope Date Ammount Start Date End Date 09/11/2006 5.000 09/11/2006 09/11/2007 In the first year you charge 4.50% If I need to muply the ammount with the %change IF the operation date is between the start and the end date, haw should I write the formula? IF(StartDate=OpeDate<=EndDate, 4.50%*Ammount,0)...this didnÂīt work! Please help as soon as possible! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying unique dates in a row of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Dates showing are not what I type | New Users to Excel | |||
| formula to add dates. | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Linear Mode
