Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12

Think Harder Suppose we wanted to find out which employee salaries are greater than and which are less than the AVERAGE. If the salary is greater than the average, let’s have Excel say, “Above.” If the salary is less than the average, Excel should return with, “Below.” This is a conditional equation. In Excel, we would use the IF function. Try it: Using the Logical Function Using our employee spreadsheet, select cell E1 and type in the label, “Compare.” Now, select Cell E2 to write the equation Click on the Function tool and select More Functions.   Select IF, the Logical function, from the list of options.