Question: 1. Cell D4 Use The IF Function To Calculate A Bonus Only For Employees Whose Performance Rating Is Greater Than 6 The Bonus Amount Will

1. Cell D4 Use The IF Function To Calculate A Bonus Only For Employees Whose Performance Rating Is Greater Than 6 The Bonus Amount Will Be 5% Of Their Annual Sales. Reference The Bonus Rate Provided In Cell F1 In Your

1. Cell D4 Use the IF function to calculate a bonus only for employees whose Performance Rating is greater than 6 The bonus amount will be 5% of their annual sales. Reference the bonus rate provided in cell F1 in your calculation. Show 0 for false results.

2. Use the Fill Handle to copy the formula from D4 to D5:D12 to calculate the bonus amount for all employees

You need to show your formular

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

Excel file link https://docs.google.com/spreadsheets/d/1zUuJBGgAhXcpHMb9_lmq1VPD-XCx6UJK/edit?usp=drive_link&ouid=106020471773606203483&rtpof=true&sd=true 1,In cell N14 , enter a function to...

1. Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center's classes....

BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...

In V15 : Using the appropriate nested functions to complete the following: If the seventh character in the employee ID is 0 or 2 or 3 or 4 or 5 , insert the employee's Region , otherwise the cell...

Merit Pay Assignment For this assignment you will determine merit pay increases for the employees of an organization. All the information you need to complete this assignment is in this document....

For this assignment you will determine merit pay increases for the employees of an organization. All the information you need to complete this assignment is in this document. Examples are provided to...

AutoSave C 90 QUIZ 2 HR DATA FILF 2021021 Excel Scarch Rajesh Dip File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial Narrow Auto Sum - A A P 82 Wrap Text T O 4 Custom...

for question 4: 4) (45 Points) WhatIf: a) Create a two-way data table for Jack's Coffee Shack showing Gross Profit for Prices per cup of coffee ranging from $1.00 to $3.00 in increments of $0.10 and...

In cell C4, enter a formula using a nested IF function to determine the amount of the monthly bonus * If the monthly sales are greater than $1,500,000 there is 4% bonus * If the monthly sales are...

Discuss why the ranking of industries by growth varies more over time than their ranking by ROIC.

The local animal shelter in Exercise 22 reported that it currently has 24 dogs and 18 cats available for adoption; 8 of the dogs and 6 of the cats are male. Are the species and sex of the animals...

SCalcET 9 7 . 4 . 0 1 6 . Evaluate the integral. ( Remember to use absolute values where appropriate. Remember the constant of integration. ) ( 3 t 2 ) / ( t + 1 ) dt

Create a project document with diagrams about Disaster Management Website including: 1. Problem statement: analyze the problem you identified and explain why the problem is significant. 2. Overview...

10. If the source v, in Fig. 10.46 is equal to 4.53 cos (0.333 x 10'r +30") V (a) obtain i, i, and ig at 1 =0 assuming no transients are present: (b) obtain an expression for vz (7) in terms of a...

Question: 1. The net income for the year ended December 31, 2018, for Tax Consultants INC. was $1,320,000. Additional information is as follows: Capital expenditures $1,600,000 Depreciation on plant...

Nine homes are chosen at random from real estate listings in two suburban neighborhoods, and the square footage of each home is noted in the following table. Size of Homes in Two Subdivisions Square...

In an effort to counteract student cheating, the professor of a large class created four versions of a midterm exam, distributing the four versions among the 328 students in the class. After the...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

123. Let U have a uniform distribution on the interval [0, 1]. Then observed values having this distribution can be obtained from a computers random number generator. Let X (1/)ln(1 U). a. Show...

127. An individuals credit score is a number calculated based on that persons credit history which helps a lender determine how much he/she should be loaned or what credit limit should be established...

b. What is the probability that not all ticketed passengers who show up can be accommodated?