How to write the formulas? + Nested IF + Mixed Ref Given the sales amounts and commission
Fantastic news! We've Found the answer you've been seeking!
Question:
How to write the formulas?
Transcribed Image Text:
+ Nested IF + Mixed Ref Given the sales amounts and commission rates, calculate commission amounts, using ONE formula that will be first entered in C3 and then copied to the whole columns C and E. (Spreadsheet template next page) Columns B-F must be formatted to show $ sign A B C D E F G 1 (Last Name) (First name) 2 Rep Q2 Q2 Q3 Name Sales ($) Commission Sales ($) Q3 Commission Commission Rates ($) ($) 3 Adam 1200 1500 Threshold ($) Rate Cut 4 Ben 299 499 2000 2.5% 5 Candy 300 400 1000 2.2% Formula Formula 6 Dan 1000 1999 500 2% 7 Edward 299 500 300 1.5% 8 Frank 300 499 Otherwise 0 9 Greg 400 499 10 Hank 1995 2000 Logic explained next pg (Note: The logic is similar to that of determining grades - A-B-C-D- If a sales amount reaches F) the threshold on column F, the rep will be entitled to the corresponding rate in G + Nested IF + Mixed Ref Given the sales amounts and commission rates, calculate commission amounts, using ONE formula that will be first entered in C3 and then copied to the whole columns C and E. (Spreadsheet template next page) Columns B-F must be formatted to show $ sign A B C D E F G 1 (Last Name) (First name) 2 Rep Q2 Q2 Q3 Name Sales ($) Commission Sales ($) Q3 Commission Commission Rates ($) ($) 3 Adam 1200 1500 Threshold ($) Rate Cut 4 Ben 299 499 2000 2.5% 5 Candy 300 400 1000 2.2% Formula Formula 6 Dan 1000 1999 500 2% 7 Edward 299 500 300 1.5% 8 Frank 300 499 Otherwise 0 9 Greg 400 499 10 Hank 1995 2000 Logic explained next pg (Note: The logic is similar to that of determining grades - A-B-C-D- If a sales amount reaches F) the threshold on column F, the rep will be entitled to the corresponding rate in G
Expert Answer:
Answer rating: 100% (QA)
The image you sent shows a spreadsheet with a formula that calculates commission amounts based on sa... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
In your accounting courses, you have studied for-profit financial accounting. In this course, we are studying government and not-for profit accounting. Who might be some of the users of governmental...
-
A function f(x) is said to have a jump discontinuity at x = a if: 1. lim f(x) exists. xa 2. lim f(x) exists. xa 3. The left and right limits are not equal. Let f(x) = 5x7, if x < 2 1 if x 2 x + 9'...
-
Cutler worked as a bartender for Bowen until they orally agreed that Bowen would have the authority and responsibility for the entire active management and operation of the tavern business known as...
-
Complete the squares to identify the conic sections Find their foci, vertices, centers, and asymptotes (as appropriate). If the curve is a parabola, find its directrix as well. x 2 - 2x + 8y = -17
-
At 3:00 a.m. on November 22, 2010, 16-year-old Sydney McLemore was driving a Mazda3 with her friend, Natalie Hurst, in the front passenger seat. The vehicle was traveling south on Ross Bridge Highway...
-
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following net cash flows: a. What is each projects NPV? b. What is each projects IRR?...
-
Why socialism or communism doesn't work in Russia but does in China? as in other countries that we see today. What do you think was the cause of the end of socialism or communism?
-
Use the template for the ABC Corp. valuation in section 2.7 to value Cisco stock. Assume that the weighted average cost of capital for Cisco is 12.6%, the growth rate for years 15 is 4%, and that the...
-
Nicole organized a new corporation. The corporation began business on April 1 of year 1. She made the following expenditures associated with getting the corporation started: (Leave no answer blank....
-
What are the different types of equity-like instruments in Islamic finance?
-
The file datafile begins with a single long value that tells you the offset of a single int piece of data within the same file. Write a program that gets the int piece of data. What is the int data?
-
How many lines does this code output? A. One. B. Two. C. Three. D. None. It doesnt compile. E. None. It throws an exception at runtime. import java.util.*; public class PrintNegative { public static...
-
How many lines of the following interface do not compile? A. Zero B. One C. Two D. Three E. Four F. None of the above 15: public interface Piano { String type = "Grand"; 16: 17: void play(); 18: 19:...
-
How many lines of the main method fail to compile? A. None B. One C. Two D. Three E. Four F. Five. 10: public class Transport { 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: } } static interface...
-
1. In photosynthesis, plants form glucose (C6H12O6) and oxygenfrom carbon dioxide and water. a). Calculate ? H ?rxn at15 ? C. b). Calculate ? S ?rxn at15 ? C. c). Calculate ? G ?rxn at15 ? C. 2....
-
7. Baladna wants to analyze process that includes delivery by suppliers, production inside the company, transportation to to its customers and information systems. Then it also wants to find out...
-
On December 31, 2014, Extreme Fitness has adjusted balances of $ 800,000 in Accounts Receivable and $ 55,000 in Allowance for Doubtful Accounts. On January 2, 2015, the company learns that certain...
-
The following table shows three cases, each with one missing element. Required: Use the bond calculator at www.fncalculator.com to determine the missing element for each case. Assume simple annual...
-
Fortune Brands Home & Security, Inc., sells Master Lock padlocks. It reported an increase in net sales from $ 3.3 billion in 2011 to $ 3.6 billion in 2012, and an increase in gross profit from $ 1.0...
-
Verify the color SU(3) representations for combinations of three or fewer quarks and antiquarks given in Eq. (19.28). Data from Eq. 19.28 qq=303=108 qq 3 3 603, 999 3 3 3 = 36315, qqq 3 3 3 1088 10,
-
Prove that Eq. (19.34) gives the simplest multi-gluon and gluon-quark states that contain an \(\mathrm{SU}(3)\) color singlet in the decomposition. Data from Eq. 19.34 (GG)1: (88)1 (Gqq) : [8 (383)8]...
-
A textile manufacturer is concerned about the strength of cotton yarn. In order to nd out whether fiber length is an important factor in determining the strength of yarn, the quality control manager...
Study smarter with the SolutionInn App