Question: can some explain this spreadsheet please so I can get a clear understanding on how to work it Copy ~ Wrap Text General Paste BIU-

can some explain this spreadsheet please so I can get a clear understanding on how to work it

can some explain this spreadsheet please so I can get a clear

Copy ~ Wrap Text General Paste BIU- - A. Conditional Format as Cell Insert Format Painter E Merge & Center Formatting Table * Styles * Clipboard Font Alignment Number Styles 013 X C E Calculating car sales compensation Number Average Car Price Number of Cars Message Straight commission " Commission w/ bonus G J A W N = S L OO V O MI A W N 32,000 27,500 34,400 23,900 46,200 12 6 35,100 10 26,700 30,700 11 49,500 22,400 26,300 8 35,900 6 10 26,700 21,600 18 41,400 19 36,500 11 20 21 Rules: Use the IF function to complete all 3 columns 22 For the 'Message' column: Message should be 'Bonus' if sales person sold 8 cars or more; otherwise 'Ne bonus' 23 For the 'Straight commission' column: Straight commission equals 3% of the total value of all cars sold. Problem 1 Problem 2 Problem 3 Type here to search OHHMaslowA TALENTED motherfucker nature

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!