# FORMULA FOR DEDUCTION

Occasional Visitor

# FORMULA FOR DEDUCTION

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.

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