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

Find The Slope && Y-Intercept Of The Graph ...Y = 6x + 11
what three parts make up a single nucleotide
what three parts make up a single nucleotide
what three parts make up a single nucleotide
Find The Slope && Y-Intercept Of The Graph ...Y = 6x + 11
what three parts make up a single nucleotide
what three parts make up a single nucleotide
Find The Slope && Y-Intercept Of The Graph ...Y = 6x + 11
what three parts make up a single nucleotide
Find The Slope && Y-Intercept Of The Graph ...Y = 6x + 11