Question: I need help on creating a formula in excel. In TOTAL 78.42 $1,254.67 80.50 $ - $1,254.67 I need cell E to calculate any thing

I need help on creating a formula in excel. In 

TOTAL78.42$1,254.6780.50
 $                    -  $1,254.67

I need cell E to calculate any thing over 80 in cell D and multiply the overage by another cell in the worksheet to give me a total in cell F

I need whatever E is (number) needs to multiply a dollar amount and can not be rounded in cell F

Step by Step Solution

★★★★★

3.49 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

IFD4G4D4G4H40 ... View full answer

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!

Q:

I need help on determining which are these contributions are deductible and which return form/s I need to use: The Dunphys contributed to the following charities and organizations, they have...

Q:

Evaluate these tax return problems with the support of tax forms, the tax assignment prompt will be shown below: You have been assigned to review the tax return.. Please casually review the return...

Q:

Below is the business plan and I need help on the accounting plan and financial plan on the business, I need to produce a presentation for that part. Introduction We are setting up a Gelato ice cream...

Q:

I have attached the corresponding lessons for assignment 8, it usually includes practice problems at the bottom that look similar to the assignment. ASSIGNMENT 7 JOB ORDER COSTING Directions: After...

Q:

I have attached the corresponding lessons for assignment 8, it usually includes practice problems at the bottom that look similar to the assignment. ASSIGNMENT 7 JOB ORDER COSTING Directions: After...

Q:

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Q:

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Q:

Please, can you help creating a formula in Excel using IF Statement (column H) and another formula using Nested IF statement (Column E). Assume that we have the following profit margins: desktop CPU...

Q:

Hi, I need help with the attached work. You can use information from ANY US publicly-traded company. Thanks! 1. Determine the firm's rd from the 10-K report in the Note to the Long-term Debt, where...

Q:

1. [-/1 Points] DETAILS SCALCET9 4.8.003. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Suppose the tangent line to the curve y = f(x) at the point (1, 4) has the equation y = 7 - 3x. If Newton's method...

Q:

New technology offers a range of benefits but it's very cheap expensive useless strange and beyond understanding

Q:

earch Scenario and activity: You are initially working with a selection of these small businesses that have been trading for three years and which now need annual trading statements to be compiled...

Q:

Your facility belongs to one of three health care delivery systems in the city. Competition is fierce. You have been asked to serve on a committee to study and recommend the retention or deletion of...

Q:

Read all the articles on journaling; what approach in the articles did you find helpful and why? Mention that you have reviewed the journaling materials and what you learned; let us know if you have...

Q:

Write a simplified printf subroutine that takes a variable amount of arguments. The first ar- gument for your subroutine is the format string. The rest of the arguments are printed instead of the...

Q:

1.Provide at least five years of Free Cash Flow Projections for the Company to be used to determine and calculate the intrinsic value of the Company. 2.Calculate the Valuation of the Company using...

Q:

Question 2 (1 point) 32 40 32 44 47 31 24 39 The median of the above data is: O 35.0 O 35.5 0 36.0 O 36.5

Q:

Air pollution generated by a steel mill is an example of a) a positive production externality. b) a negative production externality. c) a public good. d) the free-rider problem. State and local taxes...

Q:

List the types of E-R diagrams.

Q:

What are the five objectives for designing user interfaces?

Q:

Define what is meant by the term skins when used in Web design.

Q:

Many companies are using temporary workers to meet their peak demand. Is this ethically wrong? Briefly discuss.

Q:

What procedure should be used in trial-and-error worksheet approach for aggregate operations planning?

Q:

Questions 1. How is Inform helping Marks Work Wearhouse? 2. What kind of service level, lead time or annual, does Marks use? From genteel downtown Toronto to the oil fields of Alberta, Mark's Work...