Question: There arent any values plugged into this spreadsheet yet, but I am stuck on how to create an if function.. In G12, calculate Goal Percentage

There arent any values plugged into this spreadsheet yet, but I am stuck on how to create an if function..

In G12, calculate Goal Percentage by dividing the number of Goals by the number of Shots. This will display an error message because there are zeros in column F. We dont want to display error messages in the file, so an IF statement that tests the value of column F will solve this problem.

Change the formula in G12 with the following three pieces:

Test is F12 greater than zero

If the Test is True divide the number of Goals by the number of Shot

If the Test is False enter a zero

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

Suppose you are evaluating an opportunity to purchase a condominium in central Bozeman. The condominium has an asking price of $455,500. Your first step in deciding whether to buy the property is to...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

A. B. A. B. ( ( ) ) Beginning and Intermediate Algebra An open source (CC-BY) textbook Available for free download at: http://wallace.ccfaculty.org/book/book.html by Tyler Wallace 1 ISBN...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Please Answer Asap Thank you! A30. SUPPLEMENT A SPREADSHEET MODELING: AN INTRODUCTION Problems 1. Kaizer Plastic produces a variety of plastic items for pack Soek can work only with a single "Set...

I want to know how all the numbers are going and which ones are specific to organize them by cell 00 Estilos de celda v Formato y filtrar seleccionar datos G14 X V fx A B C D E F G H K L M N O Smith...

Need all parts answered ASAP! 16 A B D E F G I J L L M N Input Analysis 100 # of Events 1 2 3 4 5 6 7 Food 60% 10% $10,000.00 0.20% Attendance Merchandise 70% 5% $20,000.00 0.03% Programs Product...

The single-phase full-bridge inverter shown below is operated in the quasi-square-wave (QSW) mode (phase displacement control) at the frequency f= 100 Hz, with phase shift between half-bridge output...

Warren Buffett is chairman of Berkshire Hathaway and is one of the most successful investors of all time. He has generally outperformed the market averages since the 1950s. Explain whether Mr....

29. The figure shows a circle with centre O and radius 7 cm. The chords AB and PQ have lengths 11 cm and 13 cm respectively, and intersect at right angles at X. Find the length of OX. P OX A X Q B

give rationale why mann whitney test best statistical test for this case : Do significant differences exist between husbands and wives regarding holiday depression? There is an ordinal measure of...

Define technical words and explain how you would make decisions about their use in your business messages. (Objective 1)

Give three examples of vague or abstract words and how they could be made more specific. (Objective 1)

Define the KISS principle of business communication and discuss the advantages of its use. (Objective 1)