Hi all,
I hope this is the right board to post this question! I have a spreadsheet that was forwarded to me, it has a couple of formulas for a calculation of employee contributions to a stock/equity program. I need to figure out what the formula or expression would be, in mathematical terms, to make a computation that can be described thusly:
Here's a link to a Google Sheets document with all the information, including the description above — hope I explained it all correctly here...
Any questions (or answers!) please email me, Danny, at dvillalobos@hellovacay.com -- thanks all!
I hope this is the right board to post this question! I have a spreadsheet that was forwarded to me, it has a couple of formulas for a calculation of employee contributions to a stock/equity program. I need to figure out what the formula or expression would be, in mathematical terms, to make a computation that can be described thusly:
- first, add up an employee's total number of months worked at the company,
- then divide 5% - the percentage of the employee's contribution to the program - by the total of the previous sum,
- multiply the result by the total number of months worked
Here's a link to a Google Sheets document with all the information, including the description above — hope I explained it all correctly here...
Any questions (or answers!) please email me, Danny, at dvillalobos@hellovacay.com -- thanks all!