文档介绍：excel if函数 if函数嵌套用法
excel if函数 if函数嵌套用法 excel函数中 if函数的使用非常广泛，特别是在单条件判断的时候，用好 if函数可以帮我们完成很多功能。
最简单的 excel if函数应用
例子:下图数据在d列显示如下结果:如果数据1大于60则显示合格，否则显示不合格。
那么在d2单元格输入以下公式:
=if(a2>60,"合格","不合格")
然后向下拖拽，自动生成数据，如下图D列效果。
if函数必须的条件:
每一个 if函数必须使用英文的括号括起来;
括号内为三个数据，第一个数据是条件(如上例中的a2>60)，第二数据为满足第一个数据后返回的结果，通常使用英文的引号括起来，第三个数据是不满足第一个数据时需要返回的结果;(如果不输入第三个数据可以吗，当然可以，返回什么结果自己试试吧)
经常出现的错误:
其中的符号如逗号和引号皆为英文(也就是所谓的半角);
loan management (post) review: 1, approval criteria have been implemented; 2, the contract is correct; 3, in line with the contract, payment; 4, no other major cases against loan security;、Reviewed by: date of record form 9: qilu bank borrowing by single years of maximum amount a maximum no-loan borrowers: borrowers: ... Borrower name number, line of credit expiry date year month day to year month day maximum number of years in the loan contract are the top line opened, the borrowed and requested your bank opened credit lines above, is hereby requested. Borrower signature: date agreed to open credit lines. Customer Manager signature: date agreed to open credit lines. Loan review signature: date line cancellation-I did not use the loan amount, your bank credit lines to be cancelled. -Credit loan principal repayment, your bank credit lines to be cancelled. Borrower signature: date-unused credit lines, agree to write off loans. -Credit loan principal repayment, agree to write off loans. Customer Manager signature: date case, agree to write off loans. Loan review signature: date of record form 16: qilu self credit for credit card cancellation application form name of borrower ID number and credit limit expiration date year month day to year month day year contract number self-service card-I do not use credit, your bank credit lines to be cancelled. -Credit loan principal repayment, your bank credit lines to be cancelled. Borrower signature: date-unused credit lines, agree to write off loans. -Credit loan principal repayment, agree to write off loans.