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

algorithm to find area of circle

Someone please write me a one paragraph of when was the last time you made someone smile

The histogram represents ages of 40 people at a store that sells children's clothes. Which interval contains the median? Histogram from 0 to 35 by 5’s. age (yea

Seaside Company's manufacturing overhead is overallocated by $16,000. The following inventory account detail is provided Account Balance Allocated Manufacturin

What motivates Madame Loisel throughout the story?

________ and ___________ mix together at the hepatopancreatic ampulla.

Explain the underlying physical reason why when we conduct various heat treatments on 1018 steel we expect the modulus of elasticity to stay about the same for

Read these lines from Stanza 2 in the poem. All suddenly mount And scatter wheeling in great broken rings How do the words "scatter wheeling" affect the poem? O

A bowling alley charges $2.00 per game and will rent a pair of shoes for $1.00 for any number of games. The bowling alley has an earnings goal of $300 for the d

What is the intersection of AD and CD? Explain.