answersLogoWhite

0

There is not a single answer to that, as there are lots of logical functions. The IF function is the most common. Like a spoken language you have an "if something, do this or else do this" structure in any kind of IF function. This is broken down to a condition and true value and a false value, as follows:

=IF(Condition, True Value, False Value)

To check exam results and tell someone if they passed or failed based on a 40% pass mark, with the mark being in A10, you could have this formula:

=IF(A10>=40%, "You passed", "You failed")

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

What function in MS Excel which checks the logical condition of a statement?

IF function


What shows the logical flow of a program?

Construct/Control


Is COUNTIF an example of a logical function in Excel?

Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.Yes. It combines the logical function IF with the normal COUNT function, so that it counts values that meet a condition.


What is Validity that is related to the logical relationship between variables is known as?

construct validity


What is a function that determines whether a condition is true or false?

A logical function, such as the IF function.


What is a construct why are they useful what are examples of constructs?

A construct in philosophic is a object whose existence is supposed to depend on the mind of the other subject , that is their perception , points of reference and logical processes


Does a logical function test for specific conditions?

Yes, logical functions can test for conditions.


What are logical functions?

A logical or boolean function is one that works with logical or boolean values - values that can only be either true, or false.


What is the function used when a assigned value to a cell is dependent on a logical test?

if function


What is the function of a construction site in a city?

to construct things in a city


Which logical function returns a true result only when all its arguments are true?

The AND function.


Use this function when the value you want to assign to a cell is dependent on a logical test?

The IF function.