answersLogoWhite

0

The IF function is the main function to do it and you can also use other logical functions, like the AND function, the OR function or the NOT function.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

Which excel function would be used to calculate the total points a student earned ona aseries of tests?

The SUM function.


Which Excel function would be used to calculate the total points a student earned on a series of tests?

sum


Does thyroid come out in a drug test?

No. A physician must specifically order thyroid function tests, such as a T4 and TSH. (Other specific thyroid tests may be ordered, as well.)


What are the standard operators in Excel?

The logical operators in Excel are as follows. < is less than, > is greater than, = is equals. <= is less than or equals and >= is greater than or equals. Not equal to is written as <>.


What is the function of the tests?

Kidney function tests help to determine if the kidneys are performing their tasks adequately.


What types of blood tests can I get done through home collection in Delhi?

You can get a wide range of blood tests done through home collection in Delhi, including routine blood tests, lipid profile, liver function tests, kidney function tests, thyroid function tests, diabetes tests, and more.


500 on lung pressure test is that good?

There are different types of respiratory function tests. You will have to be more specific. Perhaps you can describe the test you did.


What are the conditional logic functions in computer applications?

Not sure what you are asking here, but here is my best guess.COMPUTER PROGRAMMING APPLICATIONS:IF - If a condition exists, do something, if not, do something else.CASE - If a condition equals CASE1 do this; if CASE2 do this; etc.WHILE - If a condition remains, keep doing something until the condition changes.EXCEL:AND(logical1,logical2,...) - tests whether the logical arguments are TRUE or FALSE. If they are all TRUE, the AND function returns TRUE to the cell. If any are FALSE, the AND function returns FALSE.IF(logical_test,value_if_true,value_if_false) - tests whether the logical_test expression is TRUE or FALSE. If TRUE, the IF function returns the value_if_true argument. If FALSE, the IF function returns the value_if_false argument.IFERROR(value,value_if_error) - tests whether the value expression is an error. IFERROR returns value_if_error if the expression is an error, or value of the expression if it is not an error.NOT(logical) - tests whether the logical argument is TRUE or FALSE. If TRUE, the NOT function returns FALSE. If FALSE, the NOT function returns TRUE.OR(logical1,logical2,...) - tests whether the logical arguments are TRUE or FALSE. If any are TRUE, the OR function returns TRUE. If all are FALSE, the OR function returns FALSE.FALSE() - takes no argument and simply enters logical FALSE in its cell.TRUE() - takes no argument and simply enters logical TRUE in its cell.


Which lab test is specific to hepatocellular damage?

Typically, the liver function tests include monitoring SGOT and SGPT. In addition, globulin and bilirubin are monitored.


How to order liver tests?

CMP (chem 14) or liver function tests (LFTs)


What are examples of biochemical tests?

Examples of biochemical tests include blood glucose tests to measure sugar levels, lipid profiles to measure cholesterol and triglyceride levels, liver function tests to assess liver health, and urine tests to check for indicators of kidney function.


What is the function of treponemal antibody tests?

Treponemal antibody tests are used to rule out false-positive results on reagin tests.