- Image and text skills
When HR calculates employee salaries at the end of the month, it is inevitable to use a table to calculate perfect attendance bonus wages.
So how to verify whether an employeecan receive a perfect attendance award based on his/her attendance days?
￭ Take this table as an example. When an employee's attendance days are greater than or equal to 25 days, he or she will receive a full attendance bonus of 200 yuan. If the attendance days are less than 25 days, the bonus will be 0 yuan.
￭First, enter the IF function in D3, the first blank cell below the "Perfect Attendance Award" column: =IF(B3>=25,"200","0"), which means if
The judged value (B3 attendance days) is "greater than or equal to" 25. If it is satisfied, it will return "200", if it is not satisfied, it will return "0"; click Enter to confirm
If the current employee is determined, you can determine whether the current employee can receive the perfect attendance award.
￭The calculated result is 0, which means it is not consistent.
￭ Then select the lower right corner of cell D3, and when it is in the shape of +, drag the cell downward, and the perfect attendance award results of other employees will be displayed.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/chu-qin-tian-shu-ji-suan-quan-qin-jiang.html
支付宝扫一扫 
评论列表（196条）
测试