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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 10:30, ilovepickles930
What can tanya do now to start preparing for the college and scholarship application process? think about her grades, activities in which she can get involved, possible part-time jobs at which she can work, and standardized tests she can take. (10 points) apex
Answers: 2
image
Computers and Technology, 22.06.2019 11:30, neekWYB
Andrina writes letters that are regularly sent to hundreds of her company’s customers. because of this, she would like for the mail merge command to be in her quick access toolbar, and she wants it to be the first button on the left. what should andrina do to place the mail merge button there?
Answers: 1
image
Computers and Technology, 22.06.2019 22:30, reinasuarez964
One of your customers wants you to build a personal server that he can use in his home. one of his concerns is making sure he has at least one backup of their data stored on the server in the event that a disk fails. you have decided to back up his data using raid. since this server is for personal use only, the customer wants to keep costs down. therefore, he would like to keep the number of drives to a minimum. which of the following raid systems would best meet the customer's specifications? a. raid 0 b. raid 1 c. raid 5 d. raid 10
Answers: 3
image
Computers and Technology, 24.06.2019 01:30, Cinders13
How can you make your column headings stand out?
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 in other subjects:

Konu
Mathematics, 07.06.2020 01:58