Are you still using Excel IF function too out ?? !! _ net _ Chinese accounting perspective needed to accountants - CPA | Certified Tax | Accounting titles | Senior Accountant | Accounting practitioners

The IF function can return the result according to the condition. But sometimes encounter complex judgments, when the formula is often written as "the Great Wall". Below the blue to the students recommended six functions, which can replace the IF for complex conditions to judge. If the limit is a minimum of 200, the formula can be changed: = MAX (C4,200) Note: on the use of TEXT function, students can first view the relevant tutorial, WeChat platform will also be uploaded in the near future TEXT usage tutorial. Note: When using VLOOKUP and LOOKUP functions for interval judgment, the first judgment interval must be in ascending order. 101 ~ 105 are "total run", "sales", " "," Customer service "," personnel "corresponding serial number C4 Formula: = CHOOSE (B4-100, "General Office", "Sales", "Finance", "Customer Service", "Personnel") With IF: IF (B4 = 104, "Customer Service", IF (B4 = 105, "Personnel"), IF (B4 = 101, "Customer Service", IF (B4 = 105, "Personnel "))))) You can also use VLOOKUP: 106, "customer service"; 105, "personnel"}, 2,0), "sales"; 103, "finance"; 104, "customer service"; 105, "personnel"