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 06:00
Which of the following is a way that advancements in technology improve humans' ability to measure air quality and protect human health? a. air quality data gathered by new instruments can be used to reduce exposure to pollutants. b. new technologies enable natural and human-made pollution sources to be located and monitored. c. air quality data gathered by new instruments can be used to predict trends in pollution over time. d. new technologies allow governments to make informed decisions about the regulation of pollution. (choose more than one)
Answers: 2
question
Computers and Technology, 22.06.2019 14:30
The “rule of 72” is used to approximate the time required for prices to double due to inflation. if the inflation rate is r%, then the rule of 72 estimates that prices will double in 72/r years. for instance, at an inflation rate of 6%, prices double in about 72/6 or 12 years. write a program to test the accuracy of this rule. for each interest rate from 1% to 20%, the program should display the rounded value of 72/r and the actual number of years required for prices to double at an r% inflation rate. (assume prices increase at the end of each year.)
Answers: 1
question
Computers and Technology, 23.06.2019 06:00
Respond to the following in three to five sentences. select the workplace skill, habit, or attitude described in this chapter that you believe is most important for being a successful employee.
Answers: 1
question
Computers and Technology, 23.06.2019 16:00
Does read theory have answers keys ?
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, 05.09.2021 20:40
question
Social Studies, 05.09.2021 20:40
question
Mathematics, 05.09.2021 20:40
question
Biology, 05.09.2021 20:40
question
Mathematics, 05.09.2021 20:40
Questions on the website: 13722363