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: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 15:20
This os integrated the processing power of windows nt with the easy-to-use gui of windows 98. windows 2000 windows 3.11 windows for workgroups windowa millennium edition
Answers: 1
question
Computers and Technology, 22.06.2019 21:30
This graph compares the total cost of attending educational institutions in texas. the graph demonstrates that the cost at private and public technical schools greatly varies.
Answers: 2
question
Computers and Technology, 23.06.2019 12:00
If you're using an existing powerpoint presentation that will receive new slides based on a word outline, select the a. slide that will appear after the new slides. b. first slide in the presentation. c. slide that will appear before the new slides. d. last slide in the presentation.
Answers: 2
question
Computers and Technology, 24.06.2019 13:30
Type the correct answer in the box. spell all words correctly. what is the default margin width on all four sides of a document? by default, the document has a margin on all four sides.
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
Mathematics, 08.10.2019 06:30