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, 23.06.2019 11:30
In cell h5 enter a formula that will calculate the percentage of attendees that went to the altamonte springs job fair in 2018.
Answers: 1
question
Computers and Technology, 23.06.2019 12:00
3. when you right-click a linked spreadsheet object, what commands do you choose to activate the excel features? a. linked worksheet object > edit b. edit data > edit data c. linked spreadsheet > edit d. object > edit data
Answers: 2
question
Computers and Technology, 23.06.2019 14:30
Open this link after reading about ana's situation. complete each sentence using the drop-downs. ana would need a minimum of ato work as a translator. according to job outlook information, the number of jobs for translators willin the future.
Answers: 3
question
Computers and Technology, 23.06.2019 15:30
The processing of data in a computer involves the interplay between its various hardware components.
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, 28.07.2019 11:30
question
Mathematics, 28.07.2019 11:30