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

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

want sum u know lol.........................

Fill in the blank Winds are deflected to the (right/left) ____ as they move into a low pressure area in the northern hemisphere

find the 4 degree polynomial with zeros at x= 1, x= -4, and x= 2 -2 i; f(0)=- 96

how were the economies of the northern and southern states different. how are they the same . what facors led them to develop differenlty

A number divided by four is three more than -11 what is the number ? 1. -2 2. -32 3. - 7/2 4. -56

Which is an example of a proper focus for an essay?

Which source is BEST when researching a company prior to an interview? OA) call the secretary or person interviewing OB) find a former employee from the company

What are the mountainous parts of the moon called

Estimate the quotient 63.5 dividend by 5

Suppose the Federal Reserve implements an expansionary monetary policy by buying bonds through open-market operations. Assume that this policy is unanticipated.