Jul 07 2019 06:59 AM
I would like to get a formula for deduction like a total number of absenteeism from 5 to 9 gets a deduction of 10% from their total salary. Kindly help me with a formula for easy entry.
Jul 07 2019 07:28 AM
@NEBIN
That could be like
=<Salary>*LOOKUP(<total number of absenteeism>,{0,5,9.5},{0,0.1,0.2})