= (Degree)
A = B
FALSE (False)
A = D
TRUE (Right)
> (Larger)
A> B
TRUE (Right)
A> C
FALSE (False)
<(Smaller)
A
FALSE (False)
A TRUE (Right) > = (Greater than or equal to) A> = B TRUE (Right) A> = D TRUE (Right) A> = C FALSE (False) <= (Less than or equal to) A <= B FALSE (False) A <= C TRUE (Right) A <= D TRUE (Right) True condition value The correct IF condition returns a value or operation. Whether it is a value or an operation, the result is returned in the cell containing the IF () function. Incorrect condition value The wrong IF condition will return a value or an operation and the result returned in the cell containing the IF () function. To understand Excel's IF function, follow the following example Follow the example of calculating bonuses based on all sales. A company pays salespeople 5% of the bonus if the price of the total sales is less than $ 5,000 per month, but if the price is over $ 5,000 per month, pay that employee 10% bonus. Write IF () function: IF (Total sales> 5000, Total sales * 10%, Total sales * 5%) - Enter the following data for columns A and B - Type the IF () function into a cell. In this case, select cell C2 - From the Insert menu, click Function . , Insert Function dialog box is displayed Or press the shortcut key combination Shift + F3 - From the Insert Function dialog box, select the IF function and click OK. The Function Argumens dialog box is displayed - In Logical_test , enter B2> 5000 . Press Tab - In Value_if_true , enter 10% . Press Tab - In Value_if_false section, enter 5% . Click OK . - The cells C3 to C6 are executed like cell C2 Note : Any time you change data from column B2 to B6, the bonus portion of the employee is automatically calculated. See also: How to use Vlookup function in ExcelExcel IF function example
How to use the IF function in Excel Picture 1
How to use the IF function in Excel Picture 2
How to use the IF function in Excel Picture 3
You should read it
May be interested
How to turn off spell checking on Microsoft OneNote
How to keep Word format when sharing documents
VLOOKUP function to use and specific examples
Use VLOOKUP to join two Excel tables together
Beautiful slide wallpapers for impressive presentations
Create Excel charts that automatically update data with these three simple steps