This is what I want
if (e2+1yr) < g2 and between e2 and i1 then multiply h2 by .25
where
e2 = 10/27/06
g2 = 10/27/10
i1 = 12/31/06 and
h2 = 4742

Is there anybody out there who can turn that into a real excel formula for me?