NEBINCopper ContributorJul 07, 2019FORMULA 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.
SergeiBaklanDiamond ContributorJul 07, 2019NEBIN That could be like =<Salary>*LOOKUP(<total number of absenteeism>,{0,5,9.5},{0,0.1,0.2})
