Vesting Schedule Formula

S

slrog123

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?
 
F

Farhad

Hi,

Try this:

=IF(AND(E2+365<G2,E2+365>E2, E2+365<I1),H2*0.25,0)

I assumed e2+year should be between e2 and I2

Thanks,
 
S

slrog123

that is great, thanks. Just one problem I am still having... if I1 becomes a
date greater than G2 the value returned needs to be zero but it seems to
still take .25 of H2
I want it to stop calculating the .25 after all shares have vested... any
suggestions?
I may be making this more complicated than it needs to be
 
F

Farhad

Hi again,

=IF(AND(E2+365<G2,E2+365>E2, E2+365<I1,G2>=I1),H2*0.25,0)
assumed if G2 and I1 would be equal it talkes 0.25

Thanks,
 
Top