Can any body tell me how to calculate the salary in the given scenario in Microsoft Excel.
I have Date of Join, current date, and total for the date to know how many years and month he served, basic salary in the cells.
Now i need is
1. calculate the date.
2. every year employee salary will be increased in different term like (e.g. if he severed for 1 year 3% will be increase if 2 years then 4% like wise up to 10 years every year 1% will be increased. by 10 he will get 12% and after 10+ same 12% will be given.
i tried it so many times i don't what is wrong. any one know the solution.?
please help.
I have Date of Join, current date, and total for the date to know how many years and month he served, basic salary in the cells.
Now i need is
1. calculate the date.
2. every year employee salary will be increased in different term like (e.g. if he severed for 1 year 3% will be increase if 2 years then 4% like wise up to 10 years every year 1% will be increased. by 10 he will get 12% and after 10+ same 12% will be given.
i tried it so many times i don't what is wrong. any one know the solution.?
please help.
