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 05:00
Which two editions of windows 7 support 64 bit cpus? choose two out of professional, business, starter, or home premium.
Answers: 1
question
Computers and Technology, 22.06.2019 06:30
Exchanging which type of data uses the least bandwidth? music photographs video voice bandwidth- the amount of data that can be moved between two points in a set time period
Answers: 1
question
Computers and Technology, 22.06.2019 11:30
Communication is the exchange of information. true false
Answers: 2
question
Computers and Technology, 23.06.2019 00:30
Write the html code to make a link out of the text “all about puppies”. it should link to a pdf called “puppies.pdf” inside the “documents” folder. the pdf should open in a new window.
Answers: 2
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, 17.04.2020 22:14
question
Mathematics, 17.04.2020 22:14
Questions on the website: 13722367