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:50
Which is the best minecraft server? a. mineplex b. worldonecraft c. 9b9t d. 2b2t
Answers: 2
question
Computers and Technology, 23.06.2019 09:50
Allison and her group have completed the data entry for their spreadsheet project. they are in the process of formatting the data to make it easier to read and understand. the title is located in cell a5. the group has decided to merge cells a3: a7 to attempt to center the title over the data. after the merge, allison points out that it is not centered and looks bad. where would the title appear if allison unmerged the cells in an attempt to fix the title problem?
Answers: 2
question
Computers and Technology, 23.06.2019 14:00
Select the correct answer. a company is currently focusing on creating specific management goals for itself. which level of maturity is the company demonstrating under the sse_ccm framework? a. performed informally b. planned and tracked c. quantitatively controlled d. well-defined e. continuously improving
Answers: 2
question
Computers and Technology, 23.06.2019 16:00
Which analyst position analyzes information using mathematical models to business managers make decisions?
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, 08.07.2020 14:01
question
Mathematics, 08.07.2020 14:01
Questions on the website: 13722360