pixiedust4756
pixiedust4756 pixiedust4756
  • 06-04-2018
  • Computers and Technology
contestada

Which function should be used to display a value based on a comparison ?
A-IF
B-COUNT
C-AVERAGE
D-MIN

Respuesta :

pbzepplin
pbzepplin pbzepplin
  • 15-04-2018
The only function that allows a comparison among the options given is the IF statement. So for example, if you want to copy all values in column A to column B, but set all negative values in column A to zero: '= if(A1 <0,0,A1)'
Answer Link

Otras preguntas

What is groupthink? suppose that you are a leader of a campus group. what can you do in order to prevent groupthink??
Indentify the terms and the coefficient of the question
PLEASE HELP Which equations could this model represent? Choose all answers that are correct. A. 3 X 2/5= M B.1 2/5 X 3 = m     C.  3 x 1 2/5 = m
Need help just 12 and 14 and answer choices
a bag contains 6 cherry, 3 orange, and 2 lemon candies. you reach in and take 3 pieces of candy at random. find the probability that you have at least 1 lemon c
how do ocean temperatures affect local weather?
Can a car be a living thing?
The haniwa figures that surrounded kofun tombs developed out of simple ______-shaped vessels
I WILL GIVE BRIANLEST TO THE PERSON WHO ANSWER IT WRITE. The function of the _______ is to convert the up-and-down motion of the piston into rotary motion that
If $240 is invested at an interest rate of 9% per year and is compounded monthly, how much will the investment be worth in 14 years? $68.39 $704.28 $842.13