Register
Which function should be used to display a value based on a comparison ? A-IF B-COUNT C-AVERAGE D-MIN
95.1k views
3 votes
Which function should be used to display a value based on a comparison ?

A-IF
B-COUNT
C-AVERAGE
D-MIN

User Michael Cornelius
by
7.2k points

1 Answer

3 votes
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)'
User Andrew Ross
by
8.2k points
← Prev Question Next Question →

No related questions found

Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
Please help me ! All you do is just put it it all in your own words ! Please this is for my reported card!i don't know how to put it in my own words because my English is not that good!
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
Link Copied!