Finding where a date falls

[Joe Gieder]

I'm trying to create an "IF" formula that has these
values in the cells: C10 is 17-Sep-02, E10 is $130.65, G6
is 2.5%, H6 is 3.00% and I6 is 2.9%.
What I need to do is if the date in C10 falls between
01/01/01 and 12/31/01 then multiply E10 ($130.65) times
G6 then use this result and multiply it with H6 then use
this result and multiply it with I6 to get the final
answer of $141.74
If the date in C10 falls between 01/01/02 and 12/31/02
then multiply E10 ($130.65) with H6 then use this result
and multiply it with I6 to get the final answer of $138.47
If the date in C10 falls between 01/01/03 and 12/31/03
then multiply E10 ($130.65) with I6 to get the final
answer of $134.55
The formula I came up with is:
=IF(AND(C11>=1/1/1<=12/31/1),E11*$G$6+E11*$H$6+E11*$I$6,IF
(AND(C11>=1/1/2<=12/31/2),E11*$H$6+E11*$I$6,IF(AND
(C11>=1/1/3<=12/31/3),E11*$I$6,)))
but this gives me a "FALSE" result therfore not doing
anything.

Thank you in advance for all the help.

Joe

 

[Molly]

Try this basic logic perhaps?

=IF(YEAR(C10)=2001,E10*$G$6+E10*$H$6+E10*$I$6,IF(YEAR(C10)
=2002,E10*$H$6+E10*$I$6,IF(YEAR(C10),E10*$I$6,)))

Another way might be:

=Choose(Year(C10)-
2000,E10*$G$6+E10*$H$6+E10*$I$6,E10*$H$6+E10*$I$6,E10*$I$6
)

Being unable to exactly duplicate your results, I think
these still need some work, but as long as you are
dealing with calendar years.

Hope this helps!