Recently, many netizens have asked the editor about the operation of the IF function in Excel. Below, the author specially introduces the operation of the IF function in Excel. I believe it will be helpful to everyone.
“ Take the following form as an example. We need to judge whether the score in it is passing. If it is greater than 50 points, fill in a few, otherwise it will be failed.
Enter the IF function, then parentheses, select a row of grade cells, then enter greater than 50, followed by a comma, use double quotation marks and then fill in the pass (note that adding quotation marks here means entering Chinese characters, if it is a number, there is no need to fill in the quotation marks), Then comma again, fill in failed.
The overall function is =IF(B2>50, "pass", "fail")
To sum up, it is to judge whether the score column of B2 is greater than 50, if so, fill in a few, if not, fill in the failed grade.
After filling in the function, double-click to fill it in, and the score judgment form will come out.
The above has explained the operation content of IF function in Excel. I hope friends in need can learn it.
