{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 cal 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 cal on 1.00%
Background image of page 1

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

View Full Document Right Arrow Icon
n if statement s are greater than $150,000 alculate a Commisson based % of Sales s are not greater than $150,000 alculate 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 Document Right 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

  • Spring '08
  • Green
  • Frank Sinatra, American jazz singers, Eddie Fisher Ella Fitzgerald Randy Crawford Anita O'Day, Bonus Merit Bonus, Sinatra Stanley Turrentine

{[ snackBarMessage ]}