Forum Discussion

NEBIN's avatar
NEBIN
Copper Contributor
Jul 07, 2019

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.

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 07, 2019

    NEBIN 

    That could be like

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