Question: How can I modify a SUM formula in Excel by adding an IF function to the formula so that if the result is bigger than

How can I modify a SUM formula in Excel by adding an IF function to the formula so that if the result is bigger than 50%, only 50% is displayed?

I am writing the following formula: =IF((K20+K21+K22+23>50, 50, (K20+K21+K22+23>50))

However, it is giving me a number bigger than 50%.

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

Q:

Please answer only the questions that are blank. please provide formulas Instructions: Select the Questions tab below to begin the assessment. There are 42 questions in this assessment. Place your...

Q:

Please answer only the questions that are blank. please provide formulas Instructions: Select the Questions tab below to begin the assessment. There are 42 questions in this assessment. Place your...

Q:

Please help I'm very confused on this Computing Overhead Rate and Preparing Schedules of Cost of Goods Stanford Enterprises has provided its manufacturing estimated and actual data for the year end....

Q:

compound interest Pane Compound Interest A Three Methods Approach Before you begin: . Look for your name on the sign-up sheet (given by your instructor) and copy the Line # Principal, and APR. Review...

Q:

Please answer thankyou. Chapter 3 Excel Simulation 1 Overhead Analysis and Preparing Schedules of Cost of Goods using Excel's SUM and Basic Math Functions 10 Starford Enterprises has provided its...

Q:

can you please solve this in formula form on excel with the formulas written out so i can see where the answers cam from please! can can you please solve it in formula form as well show the formula...

Q:

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Q:

THE ANSWERS MUST BE IN FORMULAS PLEASE. EXCEL FORMULAS ONLY, THANK YOU Inventory Costing Methods using Excel's SUM and Basic Math Functions 11 5 points . eBook Better Bottles, Inc. uses a periodic...

Q:

SOLVE ALL, SHOW FORMULAS AND EXPLANATION , THANK U S&P Enterprises has provided data from the rst three months of the year. The Controller has asked you to prepare the Cash Budget and the related...

Q:

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Q:

Questions Mr. Y. K. Chan has asked for your professional advice. Please write a report to him discussing the matters he should consider, in particular related to: Transparency and accountability of...

Q:

Suppose an environmental impact study shows that the coral reef near Port Douglas, Australia, can sustain 20 scuba diving tours per week. Discuss the pros and cons of setting a quota of 20 dive tours...

Q:

6.23 The marks for 1000 applicants in a college admission test are approximately normally distributed, with a mean of 125 and standard deviation of 15. If the college decided to consider the...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

In the Hewlett-Packard research, discuss what options the company has if it moves away from the performance pay scheme it has previously operated.

Q:

Look up the article that is the basis for focus on research 6.1. Why do you think that some of the respondents consider that their reward strategy does not operate in practice?

Q:

In case study 6.2, what would happen if business turned down and the company made little or no gains over a pay period?