3) Calculating Sales Commission Using If Statements-1

3) Calculating Sales Commission Using If Statements-1 -...

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

View Full Document Right Arrow Icon
Sales Goal $150,000 Commission Bonus 5.50% Merit Bonus 1.00% Sales Rep Sales Comission Ramsey Lewis $149,823 $1,498 Frank Sinatra $152,023 $8,361 Stanley Turrentine $209,122 $11,502 Enter an Eddie Fisher $122,023 $1,220 IF Sales Ella Fitzgerald $83,233 $832 then ca Randy Crawford $209,323 $11,513 on 5.5% Anita O'Day $148,744 $1,487 Dave Brubeck $159,872 $8,793 IF Sales then ca on 1.00
Background image of page 1

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

View Full DocumentRight Arrow Icon
n if statement s are greater than $150,000 lculate a Commisson based of Sales s are not greater than $150,000 lculate a Merit based % of Sales
Background image of page 2
Sales Goal $150,000 Commission Bonus 5.50% Merit Bonus 1.00% Sales Rep Sales Comission Ramsey Lewis $149,823 $1,498 Frank Sinatra
Background image of page 3

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

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

Unformatted text preview: $152,023 $8,361 Stanley Turrentine $209,122 $11,502 Eddie Fisher $122,023 $1,220 Ella Fitzgerald $83,233 $832 Randy Crawford $209,323 $11,513 Anita O'Day $148,744 $1,487 Dave Brubeck $159,872 $8,793 Sales Goal $150,000 Commission Bonus 5.50% Merit Bonus 1.00% Sales Rep Sales Comission Ramsey Lewis $149,823 $1,498 Frank Sinatra $152,023 $8,361 Stanley Turrentine $209,122 $11,502 Eddie Fisher $122,023 $1,220 Ella Fitzgerald $83,233 $832 Randy Crawford $209,323 $11,513 Anita O'Day $148,744 $1,487 Dave Brubeck $159,872 $8,793...
View Full Document

This note was uploaded on 04/11/2008 for the course CMIT 241 taught by Professor Green during the Spring '08 term at Guilford.

Page1 / 4

3) Calculating Sales Commission Using If Statements-1 -...

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

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