- Graphic skills
- Case
When using the logical IF function, the function returns one value if the condition is true and another value if the condition is false.
Grammar
IF(logical_test, value_if_true, [value_if_false])
logical_test: required, the condition to be tested.
value_if_true: Required, the value you want returned when logical_test evaluates to TRUE.
value_if_false: Optional, the value you want returned if the result of logical_test is FALSE.
During personnel recruitment, interview invitations can be sent to candidates.
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 condition, and enter "passed" 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/IF-han-shu-zai-shu-ju-pan-duan-zhong-de-ying-yong-ji-qiao.html
评论列表(196条)
测试