Computers and Technology

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)

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 18:30, leannhb3162
Which of these options are the correct sequence of actions for content to be copied and pasted? select content, click the copy button, click the paste button, and move the insertion point to where the content needs to be inserted. click the copy button, select the content, move the insertion point to where the content needs to be inserted, and click the paste button. select the content, click the copy button, move the insertion point to where the content needs to be inserted, and click the paste button. select the content, move the insertion point to where the content needs to be inserted, click the copy button, and click the paste button.
Answers: 3
image
Computers and Technology, 23.06.2019 09:10, babyskitt
Effective character encoding requires standardized code. compatible browsers. common languages. identical operating systems.
Answers: 1
image
Computers and Technology, 23.06.2019 13:30, powellmj9216
Spoons are designed to be used for: spring hammering. applying body filler. identifying high and low spots. sanding highly formed areas.
Answers: 3
image
Computers and Technology, 24.06.2019 07:00, erick7123
Why do we mark tlc plates with pencil and not with pen
Answers: 2
Do you know the correct answer?
In these two columns, the same nested IF function is used in cells B10 through B19. (It uses relativ...

Questions in other subjects:

Konu
Mathematics, 09.09.2020 21:01
Konu
Social Studies, 09.09.2020 21:01
Konu
History, 09.09.2020 21:01
Konu
Mathematics, 09.09.2020 21:01
Konu
English, 09.09.2020 21:01