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!
|