If function a bit it has three pieces called arguments the, Ask an Expert

Management Studies

IF function a bit. It has three pieces (called "arguments"). The first argument tests a condition. The second tells Excel to do if this condition is true. The third argument tells Excel what to do if the condition is not true. For example, if you wanted to see if the employee worked over 40 hours (and hours is in cell A1), you could say: =IF(A1>=40 If this is true, then you know they worked 40 hours of regular time, so you add this --- =IF(A1>=40,40 If this is not true, then the number of hours they did work is in A1: =IF(A1>=40,40,A1) Anybody has another example that explains the IF function? What are the arguments in the payroll example?

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M93064820

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 the demands of company as t-shirts are equally likely

1. The demands of Company A's T-shirts are equally likely between 40 and 70 shirts. Each shirt costs $3.50 and is sold at $5.00. Due to its new symposium logo, it sells at $2.50 after the symposium and only one order is ...

1 what are some of the things you can do as a ceo to help

1. What are some of the things you can do as a CEO to help reduce the incidence of medical errors? Hint: Remember the root causes of incidents. Please provide examples 2. lease write (typed) 2-3 paragraphs about how woul ...

Assignmentexecute the improve phase of the six sigma dmaic

Assignment Execute the improve phase of the Six Sigma DMAIC project including the following: Identify means to remove the causes of defects. Confirm the key variables and quantify their effects on the critical-to-quality ...

Respond to discussion question below should be a 200-word

Respond to discussion question below (should be a 200-word minimum per question): Find an example of a business practice that is fair from an Econ perspective but may not be perceived as fair from a Human perspective. ex ...

1 whatever the product the price has always been a real

1. Whatever the product the price has always been a real determinant for the future of the company. The value of a product depends on the demand of this product that has a positive or negative effect on the price 2. An a ...

David a quality inspector for hill amp clark is concerned

David, a Quality Inspector for Hill & Clark, is concerned about the quality of a batch of several thousand items that his company will be receiving next week. Hill & Clark manufactures cash registers for restaurants and ...

Letrsquos shift gears slightly from your previous work with

Let’s shift gears slightly from your previous work with Wal-Mart and think about another company and industry. In this instance, you are working at BP Amoco as a corporate trainer and have been given the opportunity to l ...

I a hospital system setting as an ithr administrator

In a Hospital system setting as an IT/HR administrator , please comprise questions related to the all of the content below. (i.e.what EMR system do you use) Technologies in place for collecting, analyzing, retrieving, st ...

1 squidward is working on his thesis and his drug

1. Squidward is working on his thesis and his drug prevention intervention failed miserably. He is worried he won't graduate if his program doesn't work so he lies and says his program is effective. Which ethical dilemma ...

Marketing intelligence is an essential component of

Marketing Intelligence is an essential component of gathering internal and external marketing related data, statistics, and information. In a sense, marketing intelligence is the corner stone of effective marketing pract ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert