ExcelL1_L1_C2_IF - 2. Write an If Statement in Column D. If...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Lutz Flutes Number Sold Quota Met? Bonus Kleinik, Sandy 5 Loser 0 Oakley, Jackie 12 Leader 600 Koontz, Jim 10 Leader 500 Bowman, Susan 16 Leader 800 Korte, Gary 8 Loser 0 Landolt, Jerry 11 Leader 550 *All Lutz Flutes Salespersons are required to sell 10 flutes a week. *Employees who meet their quota will receive a $50 bonus for each flute sold. 1. Write an If Statement in Column C. If the number sold is 10 or more, the quota met should say "Yes", if
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2. Write an If Statement in Column D. If the employee has met their quota, they get the number sold * 50, 3. Save as Excel_L1_C2_IF Hint! If you are having trouble with IF Statements, watch my If Statement Video. Click here to see the IF Statement Video if not, "No". , if not, they get 0....
View Full Document

Page1 / 2

ExcelL1_L1_C2_IF - 2. Write an If Statement in Column D. If...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online