#How to use the if function in excel table to satisfy three conditions?
The if function in the excel table must meet three conditions:
1. The composition of the if function = if (if, then, otherwise) , if function is composed of three parts, the first is judgment, if it is true, then, if it is not true, it is otherwise.
#2. Let’s open the excel table on the computer and open some data.
#3. One thing that needs special attention is that =0 in excel can be considered false.
#4. First, convert the data and apply the sum function, as shown in the figure. All absences and leave requests are converted to 0.
5. Use the if function. If =0, then the output is failed. If it is not equal to 0, the output is blank.
Recommended tutorial: "C Video Tutorial"
The above is the detailed content of How to use the if function in excel to satisfy three conditions?. For more information, please follow other related articles on the PHP Chinese website!