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!

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!

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!

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!

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!

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!

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!