- Picture and text skills
During personnel recruitment, interview invitations can be sent to candidates, but how to count the number of interviews?
￭Take this "Interview Statistics Table" as an example. We want to count the number of people who participated in the interview.
Place the cursor at B24 and click to insert the COUNTIF function.
The function of the COUNTIF function is to count the number of non-empty cells that meet the condition.
Enter F:F in the field, enter "Yes" in the condition, and click OK to count the number of people notified for interviews.
￭It is known that the qualifying condition is that the score is greater than or equal to 6, so how to convert the interview results into text?
Place the cursor at I3 and click to insert the IF function.
Enter H3>=6 in the test conditions, and enter "qualified" and "unqualified" in the true value and false value respectively.
Please note here that the entered text needs to be in double quotes in English.
Click OK to get the result, place the cursor in the lower right corner of I3 and form a cross-shaped drop-down to fill in the formula.
You can convert the interview results into text in batches.
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/ren-shi-xing-zheng-ji-qiao-ru-he-tong-ji-mian-shi-ren-shu-huo-mian-shi-jie-guo.html
支付宝扫一扫 
评论列表（196条）
测试