I can't seem to do the nested IF function in column T3. T3fx =IF(R3>=470,"Exceptional",IF(R3<470,"Good",IF(R3<430,"Needs Improvement")))KLMQRSCustomer Satisfaction1Sales figures are expressed in $1,000s.Survey Score 1-102 SalespersonIDLast NameFirst NameQ1SalesQ2SalesQ3SalesQ4SalesAnnualSalesCSS ScoreSalesScoreRankEvaluation3E10204078AdamsJoan93.0696.8297.7699.64387.289.158478.862ExceptionalE21594943BarrJanine94.9474.2696.8297.76363.788.784451.6219E31605018BennettCorey93.0693.0689.3089.30364.729.473459.4514E31898915BradshawKathryn100.0074.2686.4898.70359.448.473444.17227E21001056BreitfelderJohn100.00100.0093.0691.18384.249.065474.8938E12104087BrudnickiRandall93.0693.0684.6098.70369.429.345462.8712E16106015СаponigroAmy72.38100.0087.4288.36348.168.503433.192410E81807011CebulskiPaul85.5474.2694.9469.56324.309.349417.792711 E77698931CentryLauren93.0684.6085.5487.42350.628.222432.842512 E66506022ChoiDaisy86.48100.00100.0084.60371.088.503456.111713 E58108010CorrellRoger95.5490.5088.3699.30373.709.724470.94514 E45104044DahlmanAdam90.2485.5493.0688.36357.208.128438.482315 E50406073EscobarIsabel93.0693.0693.0693.06372.248.971461.951316 E43996918GoldackerPatrick95.8897.7691.1890.24375.068.784462.901017 E30201011HarrisJennifer100.0094.9474.2696.82366.029.252458.541518 E23401018HendersonShannon95.5497.7696.8294.26384.388.784472.22419E11122233HomanKristen96.8289.3087.3394.26367.718.128448.992020 E64301011IversSusan89.3077.34100.0089.30355.949.158447.522121 E17997945JonesCynthia87.4297.7689.3096.82371.309.158462.881122 E23107057LeeAhn99.6490.24100.0098.70388.589.158480.16123 E2620807624E76701016LopezAllison87.4274.2686.4893.06341.228.315424.3726MartinezCarl86.4893.0695.8898.70374.129.533469.4525 E30502016MeyerJoseph94.9488.36100.00100.00383.308.315466.45926 E48506067NguyenJohn93.0694.9494.9493.06376.009.158467.58727E11403044PesoliAdam71.4485.5488.3678.02323.368.941412.772928E85005035RochesTed93.0691.1895.8893.06373.188.503458.211629 E46501020RutherKara93.0696.8297.7674.26361.909.345455.351830 E28380609RyanYvette72.38100.0068.6294.00335.008.192416.9228JefferyTina31 E32703081Schmidt93.0692.1299.6482.72367.549.943466.97832 E32703082Wascher85.8888.7682.72257.368.443341.793033 9. In cell T3 write a formula (use nested IF function, i.e. IF within IF) that will:show text Exceptional if Joan's SalesScore score was 470 or highershow text Good if Joan's SalesScore score was less than 470 but higher than or equal to 430show text Needs Improvement is SalesScore score was less than 430

In this question in the excel sheet the formula have some error as it is not checking the full…

Answered: can't seem to do the neste

Engineering

Computer Science

can't seem to do the neste

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter3: Working With Large Worksheets, Charting, And What-if Analysis

Section: Chapter Questions

Problem 2.1EYK

See similar textbooks

Related questions

Q: Create a function which counts how many lone 1s appear in a given number. Lone means the number…

A: Input - Integer Output - count loon ones In this problem, we need to design the code in the JS…

Q: Create a function which counts how many lone 1s appear in a given number. Lone means the number…

A: Input - Array Output - array In this problem, we need to design the code in the JS programming…

Q: frite a function called even_checker that takes a number as an argument and prints whether the…

A: Python code: # function to check whether number is even or odddef even_checker(n): # check if…

Q: Each time you run a program that contains the rand() function a new set of random numbers is…

A: Actually, rand() function is used to generate random numbers.

Q: Create a function which counts how many lone 1s appear in a given number. Lone means the number…

A: Algorithm - Take input from user. Now use the below logic - for (let i =0;i<…

Q: ask 09 rite a function called area_circumference_generator that takes a radius of a c turns these…

A: Python code: #import math moduleimport math def area_circumference_generator(radius): # Return…

Q: Complete the function below: bool eligible(int marks){ //returns true if marks is >85 else return…

A: Requirement: Complete the function: bool eligible(int marks){ //returns true if marks is >85…

Q: A function that append two strings

A: Note, as you haven't mentioned any programming language in the above question so, I am using C to…

Q: USE THE EXAMPLE GIVEN TO CREATE A CODE FOR THE QUESTION EXAMPLE: def adverb(adjective): """Return…

A: Answer:

Q: C prog Create a recursive function that finds if a number is palindrome or not(return true or…

A: Answer: In this example, you'll learn to examine whether or not the quantity entered by the user…

Q: Exercise - Return Values Write a function called greeting that takes a String argument called name,…

A: Given:

Q: It's raining frogs and fleas. Write a function that tells you if the number of frogs in a sentence…

A: We will split the string into words separated by spaces and then check for matching substring i.e…

Q: MATLAB QUESTION - As of 2018, the population of "A city" is 646 thousand and the population of "B…

A: %Data givencity_A = 646000;city_B = 269000;year = 2018;A_dec = 7.1;B_inc = 12.9; %checking passing…

Q: the relational operator for less than or equal to?

A: The relational operator for less than or equal to

Q: Fill-in-the-Blank The _________ function compares two strings.

A: 5 Ways For Comparing Two Strings In Java String Equals Method. String Equals Ignore Case. Object…

Q: Create a function that counts the integer's number of digits. Examples count (318) → 3 count…

A: In this problem, we need to calculate the total number of integers Input - one integer Output -…

Q: 5: Complete the function that takes in a number x, and returns the value 1 if x > 0, otherwise it is…

A: Logic:- within step_function use if else to check value of x is greater than or equal to 0 or not.…

Q: C program to find the nth prime number using a helper function called findPrime(int n), which…

A: 1. Input n from the user. 2. Call the findPrime() function. 3. Iterate while loop until we get n…

Q: need to figure out how to create this function the comments show what it should do and I need to use…

A: def sumEvens(list ,i): if i<0: return 0 elif list[i]%2==0: return…

Q: How to write below function with promise async function myFunction () {return "how are you";}

A: To be determine: Write given function with promise

Q: $Create$ $a$ $recursive$ function$ $that$ $will$ $check$ $for$ $the$ $users$ $input$ $(STRING)$,…

A: The idea is to use two auxiliary arrays of size 256 (Assuming that characters are stored using 8…

Q: Complete the function below: bool eligible(int marks){ I/returns true if marks is >85 else return…

A: Complete the function: bool eligible(int marks){ //returns true if marks is >85 else return…

Q: Create a function which counts how many lone 1s appear in a given number. Lone means the number…

A: Input - Integer Output - count of lone ones In this problem, we need to design the code in the JS…

Q: This function should reverse the words in a string. A word can be considered to be any characters,…

A: Function: void reverseWords(char *s){ int len=strlen(s); int j=0; for(int i=0;i<len;i++){…

Q: strlen(); function returns:

A: option (b) is correct option

Q: Complete this code using python language #Write the conditions to check if anyone has won the game.…

A: It is defined as an interpreted, object-oriented, high-level programming language with dynamic…

Q: EMOTICON PROBLEM: Create a function that changes specific words into emoticons. Given a sentence as…

A: Please check the solution below

Q: Complete the function below: string makePalindrome(string s){ //returns the palindrome of string…

A: Complete the given function: string makePalindrome(string s){ //returns the palindrome of string s…

Q: that reads ten sets of four grades, prints the weighted average of each set, and prints the…

A: To implement this, you can store all the scores in an array which will be useful in reusability

Q: Write a program to use the check_input to create a list of valid temperatures and compute their…

A: C++ is a very famous programming language these days, It is an Object oriented programming, which is…

Q: In C++ Please if you could show your work.

A: The answer is given below.

Q: What would the atoi() function return if passed the following values? a. “65 " b .…

A: C-function atoi() that takes a c-string type argument as input and converts the given c-string value…

Q: retermine if the following argument

A: 1. p ~p r ~r r=>~p p=>~r 0 1 0 1 1 1 0 1 1 0 1 1 1 0 0 1 1 1 1 0 1 0 0 0…

Q: In c++ (just pattern, not table) write a recursive function program that prompts the user to enter…

A: Actually, c++ is a powerful general language. It is a high level language.

Q: The pointer variable is defined with: O & operator O % operator operator. O None of the answers are…

A: Answer in step 2

Q: the blanks to complete the fore following argument:

A: Given that the logical proof for the argument.

Q: Recursive function is similar to which of the ?following None of above O Loop O If-else O Switch…

A: Recursive function means function calls itself. The function calls itself with changed in parameter…

Q: The function strlen(); will

A: The function strlen(); None return the number of characters of given string return the given string…

Q: void main () { char str1[] "abcd"; char str2[] "abcd"; if(str1==str2) printf("Equal"); else…

A: Unequal

Q: You can use the following functions to do case insensitive string comparison. Place them in your…

A: It is defined as a general purpose programming language. It is object oriented and has generic…

Q: what is remainder operator ?

A: Normally, the division operation calculates the quotient and remainder part. Java Virtual Machine…

Q: $Create$ $a$ $recursive$ function$ $that$ $will$ $check$ $for$ $the$ $users$ $input$ $(STRING)S,…

A: In above question we need to find the unique characters count and their combinations. A permutation,…

Q: Multiple Choice The function ComputeSum receives a positive integer n as the input and returns the…

A: Given, ComputeSum(n){ If n=1, then Return (3) y:=ComputeSum(n-1) return(?) } Here we have to…

Q: (Even or Odd) Write a program that inputs a series of integers and passes them one at a timeto…

A: C Programming The general-purpose programming language C is very well-liked, easy to learn, and…

Q: d) [if time allows] Improve the program written in part (c) by letting the user to specify two…

A: Program Approach:- Include a necessary header file. Defining the method input_string. Ask the user…

Q: Note that the values are in column f. I want a fomula that will sum the positive values only. USE…

A: Given:

Q: ucfirst(); function: O a. converts all leters into upper case O b. converts first letter into…

A: I have given an answer in step 2.

Q: Computer Science create function getRandom

A: SOLUTION IN BELOW STEP

Q: Write C++ code for the lexicographic arrangement of numbers.The user should be allowed to enter any…

A: Given : Write C++ code for the lexicographic arrangement of numbers.The user should be allowed to…

Question

I can't seem to do the nested IF function in column T3.

T3
fx =IF(R3>=470,"Exceptional",IF(R3<470,"Good",IF(R3<430,"Needs Improvement")))
K
L
M
Q
R
S
Customer Satisfaction
1
Sales figures are expressed in $1,000s.
Survey Score 1-10
2 SalespersonID
Last Name
First Name
Q1Sales
Q2Sales
Q3Sales
Q4Sales
AnnualSales
CSS Score
SalesScore
Rank
Evaluation
3
E10204078
Adams
Joan
93.06
96.82
97.76
99.64
387.28
9.158
478.86
2
Exceptional
E21594943
Barr
Janine
94.94
74.26
96.82
97.76
363.78
8.784
451.62
19
E31605018
Bennett
Corey
93.06
93.06
89.30
89.30
364.72
9.473
459.45
14
E31898915
Bradshaw
Kathryn
100.00
74.26
86.48
98.70
359.44
8.473
444.17
22
7
E21001056
Breitfelder
John
100.00
100.00
93.06
91.18
384.24
9.065
474.89
3
8
E12104087
Brudnicki
Randall
93.06
93.06
84.60
98.70
369.42
9.345
462.87
12
E16106015
Саponigro
Amy
72.38
100.00
87.42
88.36
348.16
8.503
433.19
24
10E81807011
Cebulski
Paul
85.54
74.26
94.94
69.56
324.30
9.349
417.79
27
11 E77698931
Centry
Lauren
93.06
84.60
85.54
87.42
350.62
8.222
432.84
25
12 E66506022
Choi
Daisy
86.48
100.00
100.00
84.60
371.08
8.503
456.11
17
13 E58108010
Correll
Roger
95.54
90.50
88.36
99.30
373.70
9.724
470.94
5
14 E45104044
Dahlman
Adam
90.24
85.54
93.06
88.36
357.20
8.128
438.48
23
15 E50406073
Escobar
Isabel
93.06
93.06
93.06
93.06
372.24
8.971
461.95
13
16 E43996918
Goldacker
Patrick
95.88
97.76
91.18
90.24
375.06
8.784
462.90
10
17 E30201011
Harris
Jennifer
100.00
94.94
74.26
96.82
366.02
9.252
458.54
15
18 E23401018
Henderson
Shannon
95.54
97.76
96.82
94.26
384.38
8.784
472.22
4
19E11122233
Homan
Kristen
96.82
89.30
87.33
94.26
367.71
8.128
448.99
20
20 E64301011
Ivers
Susan
89.30
77.34
100.00
89.30
355.94
9.158
447.52
21
21 E17997945
Jones
Cynthia
87.42
97.76
89.30
96.82
371.30
9.158
462.88
11
22 E23107057
Lee
Ahn
99.64
90.24
100.00
98.70
388.58
9.158
480.16
1
23 E26208076
24E76701016
Lopez
Allison
87.42
74.26
86.48
93.06
341.22
8.315
424.37
26
Martinez
Carl
86.48
93.06
95.88
98.70
374.12
9.533
469.45
25 E30502016
Meyer
Joseph
94.94
88.36
100.00
100.00
383.30
8.315
466.45
9
26 E48506067
Nguyen
John
93.06
94.94
94.94
93.06
376.00
9.158
467.58
7
27E11403044
Pesoli
Adam
71.44
85.54
88.36
78.02
323.36
8.941
412.77
29
28E85005035
Roches
Ted
93.06
91.18
95.88
93.06
373.18
8.503
458.21
16
29 E46501020
Ruther
Kara
93.06
96.82
97.76
74.26
361.90
9.345
455.35
18
30 E28380609
Ryan
Yvette
72.38
100.00
68.62
94.00
335.00
8.192
416.92
28
Jeffery
Tina
31 E32703081
Schmidt
93.06
92.12
99.64
82.72
367.54
9.943
466.97
8
32 E32703082
Wascher
85.88
88.76
82.72
257.36
8.443
341.79
30
33

9. In cell T3 write a formula (use nested IF function, i.e. IF within IF) that will:
show text Exceptional if Joan's SalesScore score was 470 or higher
show text Good if Joan's SalesScore score was less than 470 but higher than or equal to 430
show text Needs Improvement is SalesScore score was less than 430

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Q17/ Write a program to compute and display a person's weekly salary as determined by the following conditions: If the hours worked are less than or equal to 40, the person receives $12.00 per hour; otherwise, the person receives $480.00 plus $18.00 for each hour worked over 40 hours. The program should request the hours worked as input and display the salary as output. HINT: using functions.
Use the IF function to calculate the down payment starting in H11. If type = Finance, then the down payment is 10% of the amount. Else, it is equal to the amount.
Working overtime is defined as having worked more than 40 hours during the week. Given the variable hoursWorked , write an expression that evaluates to true if the employee worked overtime. use C++
Q1) Write a function that will take Bid and ask price in dollars, and a) return dollar bid-ask spread (name the function in_ dollar_bidask ) b) compute proportional bid-ask spread (name the function in_dollar_bidask ) c) Write test code to test a) and b)
determine if each following statement is True or False
Use Type Switches and Asertions sparingly function to write go code. Question is right , please donot reject it Output 70< nil>
Given the following: printf ( “Enter your age in years: “ ); scanf ( “%d”, &age_in_years ); int is_voting_age = ( age_in_years >= 18 ); int is_drinking_age = ( age_in_years >= 21 ); int can_be_president = ( age_in_years >= 35 ); int is_senior_citizen = ( age_in_years >= 65 ); When the age entered is 33, what are the values of the variables above? When the age entered is 12, what are the values of the variables above? Write an IF statement in a function to print ‘Yes’ for each value above that is true.
Determine if the following statements should use permutation or combination Five friends posing for a picture-taking at the park. Arranging six pots of different plants in a row
I need help writing a Boolean expression that is true if and only if a student is a senior who is majoring in either Information Technology or Computer Science and has a GPA of at least 3.5 but not higher than 3.85. Assume that the student’s year in school is stored in the variable year, the student’s major is stored in the variable major, and the student's GPA is stored in the variable gpa. Use parentheses to indicate clearly the order in which the operations should be evaluated.
This assignment is to write a program to score the rock-paper-scissors game. Each of two playersenters R, P, or S. The program than announces the winner as well as the basis for determiningthe winner: "Paper covers rock", "Rock breaks scissors", "Scissors cut paper", or "Draw, nobodywins". Use nested if statements (or if-else-if) to do the homework.In this assignment, you will write two functions, getThrow and checkWinner. Your getThrowfunction will be given an int representing a player number to prompt and will ask that player toenter one of rock, paper, or scissors, repeating until they enter a valid input and returning a charrepresenting the result. Your checkWinner function will be given two chars representing the throwsof the two players and will print the results of the contest. Both functions must accept both upperand lowercase inputs.Your main function will call both functions to form a complete program. Remember that youcan call a function multiple times. Your program will be…
Q16/ Write a program that accepts a user-entered number and calculates the square root. Before calculating, check that the number is negative, and isn't zero. If either condition occurs, display a message stating that the operation can't be calculated. HINT: using functions.
Using functions, write a program that will solve the problem: Create a program that will display the nth numbers in the Fibonacci series. The length of the series depends on the user's input. Use user-defined function and appropriate conditional and looping statements to solve the given problem.