FORMULA FOR DEDUCTION

[NEBIN]

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.

[#2]

@NEBIN 

That could be like

=<Salary>*LOOKUP(<total number of absenteeism>,{0,5,9.5},{0,0.1,0.2})