Excel

profileSL18
Sales.xlsx

SalesEntryForm

CKG Auto
Sales Rep Sales Data
Entry Form
Sales Rep Name
Sales Date
Sales Amount
Commission ERROR:#NAME?
Commission Percentage: 7.00%

SalesList

CKG Auto
Sales Rep Commission Data
For the Current Month
Sales Rep Name Sales Date Sales Amount Commission
Brady Anderson 7/14/16 $2,200.00 $165.00
David Green 7/14/16 $1,900.00 $142.50
Tasha Johnson 7/14/16 $1,450.00 $108.75
Violet Newhouse 7/14/16 $1,875.00 $140.63
Tasha Johnson 7/16/16 $1,750.00 $131.25
Brady Anderson 7/17/16 $2,500.00 $187.50
David Green 7/17/16 $1,800.00 $135.00
Richard Taylor 7/17/16 $2,300.00 $172.50
Tasha Johnson 7/17/16 $1,750.00 $131.25
Richard Taylor 7/19/16 $2,525.00 $189.38
Richard Taylor 7/19/16 $1,775.00 $133.13
Tasha Johnson 7/19/16 $1,825.00 $136.88
Violet Newhouse 7/19/16 $1,875.00 $140.63
Violet Newhouse 7/20/16 $1,950.00 $146.25
Tasha Johnson 7/21/16 $1,875.00 $140.63
Tasha Johnson 7/24/16 $1,790.00 $134.25
Violet Newhouse 7/24/16 $1,875.00 $140.63