hi, I am looking to do a multiple if statements to calculate a value based on shares vesting at different % in different years. For example, in year 1, 15% of your allotted shares vest, a further 20% in years 2-4 and the last 25% in the final year. I keep getting a message saying that if I am not trying to type a formula, then I must not put +/- at the start of things.
I need to do two formulas (columns h & I). Column H gives the shares that vest only when full years have been completed. COlumn I calculates by day.
If anyone could help me please as I have got close but cannot finish the formula to take in the five years and am going crazy
Bradser
Bookmarks