subject

In these two columns, the same nested if function is used in cells b10 through b19. (it uses relative cell references.)

what is most likely the function entered into cell b10?

=if(or(a10> -3,a10< -1),a10*0.5,a10)
=if(and(a10> -3,a10< -1),a10*0.5,a10)
=if(or(a10< -3,a10> -1),a10*0.5,a10)
=if(and(a10< -3,a10> -1),a10*0.5,a10)

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 22:40
In this lab, you complete a python program that calculates an employee's annual bonus. input is an employee's first name, last name, salary, and numeric performance rating. if the rating is 1, 2, or 3, the bonus rate used is .25, .15, or .1 respectively. if the rating is 4 or higher, the rate is 0. the employee bonus is calculated by multiplying the bonus rate by the annual salary.
Answers: 1
question
Computers and Technology, 24.06.2019 00:00
For the following example of making a peanut butter and jelly sandwich, identify which are inputs, processes, or outputs: bread scooping and spreading peanut butter plate scooping and spreading jelly finished sandwich putting two pieces of covered bread together dirty plate crumbs
Answers: 2
question
Computers and Technology, 24.06.2019 16:00
Your is an example of personal information that you should keep private.
Answers: 1
question
Computers and Technology, 24.06.2019 17:40
When analyzing data sets, such as data for human heights or for human weights, a common step is to adjust the data. this can be done by normalizing to values between 0 and 1, or throwing away outliers. for this program, adjust the values by subtracting the smallest value from all the values. the input begins with an integer indicating the number of integers that follow. ex: if the input is 5 30 50 10 70 65, the output is: 20 40 0 60 55
Answers: 1
You know the right answer?
In these two columns, the same nested if function is used in cells b10 through b19. (it uses relativ...
Questions
question
English, 10.01.2020 02:31
Questions on the website: 13722362