Question: Use the IF function to complete all three columns. For the message column message should be bonus if sales person sold 8 cars or more

Use the IF function to complete all three columns. For the message column message should be bonus if sales person sold 8 cars or more otherwise no bonus. For the straight commission column, straight commission equals 3% of the total value of all cars sold. For the commission w/ bonus column, should be straight commission,plus a bonus if the salesperson sold at least 8 cars. the bonus is 20% of commission.

Rules Use the it function to complete at 3 co For the 'Message' column: Me For the 'Straight commission' columns For the 'Commision wibonus' column bores if the sales person sold of lead hutten Problem 9 Type frere to search TALENTED

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!

need a better understanding of using the if function with this spreadsheet please AutoSave6 53 BMG275_Mod 17 IF Function (1) . Last Modified: 20h ago . O Search File Home Insert Page Layout Formulas...

can some explain this spreadsheet please so I can get a clear understanding on how to work it Copy ~ Wrap Text General Paste BIU- - A. Conditional Format as Cell Insert Format Painter E Merge &...

Need some assistance with this spreadsheet please. Paste - Format Painter Chipboard Arial 12 - AK EE. Wrap Test BIU-- A - A Es Merge & Center Font Alignment General $ % 4.23 Insert De Conditional...

The Nelson Company is planning a new division to make a specialised product. This is the only product that the division will make. As a financial analyst in the planning department, youve been asked...

Preparing the sales report - what you are required to do: Download the start file and rename it to your name and save it on desktop. Call your lecturer to check if you get the right file. You must...

Use the fill function to complete the Revenue row from Year 1 to Year 8 . Use the growth trend. 5 . Using absolute cell references to help you, calculate the cost of goods sold for all years. 6 ....

I need to complete phase 3 of the schnappauf family case. PHASE lI-CHAP'I'EIIE 5-5 This is the seeenci phase eF the te:t tenIIn prehlem Ire-u began at the end efhapter 1r. Th' phase uf the tax return...

I need help working through this problem. Most of the work I have completed but I need help ensuring that my answers are correct before submitting the assignment. I have attached the problem...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

I have the following completed: 1120, 2220,1125 A , 1125 E I need the following forms completed asap:SCHEDULE D and G form 4562, form 4797 schedule detail M-1 it should be fairly easy to do the rest...

Mirza Sdn Bhd is having cash flow problems due to current economic condition. The company plans to factor RM140,000 of its accounts receivable to a factoring firm, saving RM600 per month in...

Consider the electric field at points A, B, and C in Fig. 16-48. First draw an arrow at each point indicating the direction of the net force that a positive test charge would experience if placed at...

An American call option Group of answer choices requires the holder of the option to buy the stock at a specified price on or before the expiration date. gives the holder of the option the right but...

(python3.5.1 )Write a new version of the program that converts an integer into its English name (found in "int_name.py") to use a dictionary instead of if statements. ##(Int_name,py:) ## ## # This...

1. Why do national income accountants compare the market value of the total outputs in various years rather than actual physical volumes of production? What problem is posed by any comparison over...

7. About differing perspectives on whether growth is desirable and sustainable.

2. Why are only final goods counted in measuring GDP for a particular year? Why is the value of used furniture thats bought and sold not counted? LO1