The “Formula Builder” pane will display at the right side of the Excel window. Now you will see the IF Function dialog box, with a place to enter each of the three arguments. Mac Users should click on the Formulas tab, then click the “Logical” tool list arrow, and choose IF (see Figure 3.9). Mac Users: There is no “Function Library” group for Excel for Mac. On the Formulas tab, in the Function Library group, find the IF function on the Logical pulldown menu (see Figure 3.9). But, if he/she scores less than 70%, he/she is failing. If the student scores 70% or better, he/she will pass the class. In column Q we would like Excel to tell us whether a student is passing – or failing the class. Then, if B7 does not equal 14, nothing will be displayed in this cell. Let’s say that you type the double quotes here. You can enter the same instructions here as you did above.
0 Comments
Leave a Reply. |