Question

2.

a.

To be eligible for a company bonus, an employee must earn a yearly sales commission over $10,000 or more and have added at least 50 new sales accounts in that same year. In a spreadsheet, the employees’ names are listed in column A, their commissions are entered in column B, and the total number of new sales accounts are entered in column C. Write an IF statement in cell D2 for the employee in row 2 to be copied for column D that will display “Bonus” or “No Bonus”.

		=IF(AND(B2>=10000,C2>=50),”Bonus”,”No Bonus”)
		=IF(AND(B2>10000,C2>=50),”Bonus”,”No Bonus”)
		=IF(OR(B2>10000,C2>50),”Bonus”,”No Bonus”)
		=IF(AND(B2>=10000,C2>50),”Bonus”,”No Bonus”)

b.

Interpret the following Excel statement entered in cell B2 of a worksheet.
=IF(A2=”Green”,A2,IF(A2=”Blue”,A2,IF(A2=”Red”,A2,”Other”)))

		If the value in cell A2 equals “Green”, “Red”, or “Blue”, then the text, “Other” will be displayed in cell B2.
		If the value in cell A2 equals “Green”, then the text, “Green”will be displayed in cell B2. If the value in cell A2 equals “Blue”, then the text, “Blue”will be displayed in cell B2. If the value in cell A2 equals “Red”, then the text, “Red”, then the text, “Red” will be displayed in cell B2. If none of these are true, then the text “Other” will be displayed in cell B2.
		If the value in cell A2 equals “Green”, then the text, “Green” will be displayed in cell B2. Otherwise, the text, “Other” will be displayed in cell B2.
		If the value in cell A2 equals “Green”, “Red”, or “Blue”, then the numerical value of A2 will be displayed in cell B2.

c.

Interpret the following Excel statement entered in cell C1 in a worksheet. Cells A1 and B1 contain numerical data.
=IF(AND(A1>0,B1>0),”Both Positive”,”Both Not Positive”)

		If the value in cell A1 is larger than 0 or the value in cell B1 is larger than 0, then the text, “Both Positive” will be displayed in cell C1. Otherwise, the text, “Both Not Positive” will be displayed in cell C1.
		If the values in cells A1 and B1 are larger than 0, then the text, “Both Positive” will be displayed in cell C1. Otherwise, the text, “Both Not Positive” will be displayed in cell C1.
		If the values in cells A1 and B1 are larger than or equal to 0, then the text, “Both Positive” will be displayed in cell C1.
		If the values in cells A1 and B1 are larger than or equal to 0, then the text, “Both Positive” will be displayed in cell C1. Otherwise, the text, “Both Not Positive” will be displayed in cell C1.

Answer 1

1\a)

=IF(AND(B2>=10000,C2>=50),”Bonus”,”No Bonus”)

b)

If the value in cell A2 equals “Green”, then the text, “Green”will be displayed in cell B2. If the value in cell A2 equals “Blue”, then the text, “Blue”will be displayed in cell B2. If the value in cell A2 equals “Red”, then the text, “Red”, then the text, “Red” will be displayed in cell B2. If none of these are true, then the text “Other” will be displayed in cell B2.

c)

If the values in cells A1 and B1 are larger than 0, then the text, “Both Positive” will be displayed in cell C1. Otherwise, the text, “Both Not Positive” will be displayed in cell C1.