Calculations of Severance pay

[AlaminK]

Hello there,

I have this dataset in the given Excel file. The calculations took too much time and space because I had mostly used the basic Excel formula. Could you kindly provide me with one specific formula to get the output as highlighted in yellow in the example?

Regards,
Al

 

[arnelgp]

you should first consult your government (agency) for the correct formula for the Severance pay computation.