Question: Please provide a step by step solution that would give me a result in 0 for cell B30 please note that b29=NO the amount in

Please provide a step by step solution that would give me a result in 0 for cell B30

please note that b29=NO the amount in B14 is 83,227 and they want to know if its greater than 125,000 which result in b29 result to NO

1.In cell B29, insert a formula with an IF statement that returns Yes if the total San Francisco sales 83,227 for the month of January is greater than or Equal to the Sales Quota of $125,000.If Sales is not greater than $125,000, insert the word No.Use absolute addressing in your formula.

In cell B30, insert a formula with an IF statement. If B29 is Yes, multiply the amount in B14 by 2%. If B29 is No, insert a zero. Use absolute addressing in your formula.

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 Accounting Questions!

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

now//You are asked to price some options on KYC stock. KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent,...

Need ONLY an answer to Part C, step 1, questions 1 and 3. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most...

Locate and use an audited annual financial statement STEP 1: The Company Assigned to you Find the most recent audited annual financial statement online for the Canadian public company assigned to the...

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

This a group assignment. i need to answer a simple question about WACC. Plz help me. THE PATHWAY FROM CONSTRUCTION TO PRODUCTION 2003 The dream begins 2004 Cloudbreak identified 2005 S&P/ASX 200...

Part I you are asked to use the introductory sentence about the tax payer and complete paragraph items 14 and 16. You will also use item 18 for needed Social Security numbers. Do not do additional...

Just need answer to part C question step 1, chart of accounts(1st question in step 1). Only need answer to that. Term Project Part A: Understanding Financial Statements Locate and use an annual...

Need the answer to Part C question only questions regarding the Step 2 - 7th question. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company...

Distinguish between the BCG matrix and the nine-cell matrix, and describe their applications.

In the third order Taylor expansion of u=x*0.83*y^(1-0.83) around (x,y)=(1,1), what is the coefficient of (x-1)*(y-1)^2? Write the answer as a number in decimal notation with at least two digits...

In AVNRT, the atrial rate and ventricular rates are _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Group of answer choices inversely related proportional to the number of ectopic foci absent identical

Question 1 6 ( 1 . 2 5 points ) If an agent makes agreements on behalf of the principal in a fiduciary relationship of trust and confidence, is the principal liable? No , because although the...

a. On the dominance continuum, place a mark where you feel she belongs.

1. Oprah Winfrey is one of Americas most popular talk-show hosts. Consider the behaviors she displays on her show, and then complete the following exercises:

4. This chapter places considerable emphasis on the role spouses play in terms of the success of an overseas manager. What other steps should companies take to increase the likelihood of a successful...