| |
18.3.7.=IF(A1>A2, "Good!", "Bad!"): if the value in A1 is greater than the value in A2, then the text "Good!" is returned. Otherwise "Bad!" is returned. |
|
Input the formula: =IF(A1>A2, "Good!", "Bad!")
|
|
![Input the formula: =IF](../../Microsoft-Office-Excel-2007Images/ifa1gta2_good_bad_If_Value_In_A1_Is_Greate___Input_Formula_ifa1a2_good_bad.PNG) |
18.3.IF | | 18.3.1. | IF(logical_test,value_if_true,value_if_false) specifies a logical test | | ![IF(logical_test,value_if_true,value_if_false) specifies a logical test](../../Microsoft-Office-Excel-2007Images/Iflogical_testvalue_if_truevalue_if_false_Specifies_Lo___Input_Formula_ifa2100within_Budgeto.PNG) | | 18.3.2. | =IF(A2=100,SUM(B5:B15),"") | | ![=IF(A2=100,SUM(B5:B15),](../../Microsoft-Office-Excel-2007Images/ifa2100sumb5b15___Input_Formula_ifa2100sumb5b15.PNG) | | 18.3.3. | =IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))) | | 79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))" src="http://www.java2java.com/Tutorial/Microsoft-Office-Excel-2007Images/ifa2gt89aifa2gt79b_Ifa2gt69cifa2gt5___Input_Formula_ifa289aifa279b_Ifa269.PNG" width=200 height=40> | | 18.3.4. | Combine IF, AND and CHOOSE to display month name | | ![Combine IF, AND and CHOOSE to display month name](../../Microsoft-Office-Excel-2007Images/Combine_If_And_And_Choose_To_Display_Month_Name___Input_Formula_ifanda10a113choosea1j.PNG) | | 18.3.5. | Combine IF, OR and CHOOSE to display month name | | ![Combine IF, OR and CHOOSE to display month name](../../Microsoft-Office-Excel-2007Images/Combine_If_Or_And_Choose_To_Display_Month_Name___Input_Formula_ifora11a112thatNo.PNG) | | 18.3.6. | =IF(A1>A2, A1, A2): if the value in A1 is greater than the value in A2, then the value in A1 is returned. If not, then the value in A2 is returned. | | ![=IF(A1>A2, A1, A2): if the value in A1 is greater than the value in A2, then the value in A1 is returned. If not, then the value in A2 is returned.](http://www.java2java.com/Tutorial/Microsoft-Office-Excel-2007Images/ifa1gta2_A1_A2_If_Value_In_A1_Is_Greater_Than_Th___Input_Formula_ifa1a2_A1_A2.PNG) | | 18.3.7. | =IF(A1>A2, "Good!", "Bad!"): if the value in A1 is greater than the value in A2, then the text "Good!" is returned. Otherwise "Bad!" is returned. | | ![=IF(A1>A2,](http://www.java2java.com/Tutorial/Microsoft-Office-Excel-2007Images/ifa1gta2_good_bad_If_Value_In_A1_Is_Greate___Input_Formula_ifa1a2_good_bad.PNG) |
|