All employees with one or more years of service are eligible for a bonus. Pay Grade 1 employees receive $3,000 (cell U2), Pay Grade 2 employees receive $6,000 (cell U3), and Pay Grade 3 employees receive $8,000 (cell U4). In the Bonus column, use the IFS function to calculate the bonus. For employees in pay grades over 3, there is no bonus. (HINT: the AND function is used in the logical test within the IFS function because you have to test if the years of service >=1 AND each specific pay grade)

All employees with one or more years of service are eligible for a bonus. Pay Grade 1 employees receive $3,000 (cell U2), Pay Grade 2 employees receive $6,000 (cell U3), and Pay Grade 3 employees receive $8,000 (cell U4). In the Bonus column, use the IFS function to calculate the bonus. For employees in pay grades over 3, there is no bonus. (HINT: the AND function is used in the logical test within the IFS function because you have to test if the years of service >=1 AND each specific pay grade)

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 2.11CP

See similar textbooks

Similar questions

In column J, you want to display Early Admission, Early Rejection, Admit, or Reject, respectively, to indicate the final decision. In cell J11, enter the IFS function. If Admit Early is Yes, display the text Early Admission. If Reject Early is Yes, display the text Early Rejection. If the score is greater than the threshold score in cell B6, display Admit. If the score is less than or equal to the threshold score in cell B6, display Reject. Use mixed reference to cell B6.
Correct answer will be appreciated.else downvoted.
Here__denoting the number of test cases. The description of T test cases follows. .
In cell N3, enter a formula using the IF function and structured references as follows to determine which employment level Tiffany Adams is qualified for: The IF function should determine if the employee's Years of Experience is greater than or equal to 4, and return the value 2 if true or the value 1 if false. Fill the formula into the range N4:N32, if necessary.
In Column I - We are going to give a bonus based on the profit margin. Create an IF STATEMENT where if the profit margin is greater than 74% the bonus is $5,000 and if it is not the bonus is $2,000. What is the value in Cell I3
In cell F7, create a formula that calculates the salary for Joan Dickinson. Her salary is calculated by adding her base salary (cell B7) to her total bonus (cell E7). (Hint: Do not use the SUM function.) To calculate the salary for all of the employees, copy the formula you created and the formatting in cell F7 into the range F8:F10. Kelly wants to view employees’ bonuses as a percentage of their base salary. In cell G7, enter a formula without using a function that divides Joan’s total bonus (cell E7) by her base salary (cell B7).
Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.
Please help with the followng:
Lael is constantly looking for students who are interested in running for office in student organisations. In cell M2, insert the following formula, which uses a nested IF function and structural references to assess if a student has already been elected to office in a student group, and if not, whether that student fits the conditions to run in the future: If the Elected column value equals the string "Yes," the formula should display Elected as the text. Otherwise, the formula should check if the value in the Finance Certified column is equal to the word "Yes" and return the text Yes if it is and No if it is not. What is the formula that should be entered into Excel?
In the following procedure, the parameter age represents a person's age. The procedure is intended to return the name of the age group associated with age. People who are under 18 are considered minors, people who are 65 and older are considered senior citizens, and all other people are considered adults. The procedure does not work as intended. Line 1: PROCEDURE ageGroup(age) Line 2: } result "adult" Line 3: Line 4: IF(age 65) Line 5: { Line 6: result "senior citizen" Line 7: Line 8: RETURN(result) Line 9: Line 10: result "adult" Line 11: IF(age < 18) Line 12: Line 13: result "minor" Line 14: Line 15: RETURN(result) Line 16: } ill cause the procedure to work as intended?
: The general equation for the distance, d, in meters that a free falling body has travelled (neglecting air friction) is Gravity on Mars is, g = 3.711 m/sec2. Create a table of time vs distance traveled on Mars for each of the following conditions. You should have 3 tables, one for each part a b c, when you are finished. Your tables must have column headings. You do not necessarily need to use Properties.VariableNames, but I prefer it. Values of time from 0 to 120 seconds in 10 second increments. Ten evenly spaced values of time from 0 to 120 seconds. (Evenly spaced does not mean 12 seconds between each!) Fifteen logarithmically spaced values of time from 0.1 seconds to 100 seconds
Correct answer needed asap. Wrong solution will get downvote.