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.


How many logical conditions can you include in Excel in the AND function?

You can have up to 255 conditions in the AND function.