answersLogoWhite

0


Best Answer

IF function

User Avatar

Wiki User

7y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

8y ago

The standard answer is the IF function, but there are other logical functions that can check the logical condition of a statement such as the AND function and the OR function.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What function in MS Excel which checks the logical condition of a statement?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is logical statement?

A logical statement is one that will return a boolean or a logical "True" or "False" output. It is used in cases where conditions need to be executed. For ex: lets say you write a system that checks the age of the visitors to a bar, the system should only allow people who are over 18 yrs of age. So the logical condition will be like below: if(age > 18) then "Let the Customer Enter" else "The customer is a minor, send them back to stay out of trouble"


Do loops for dummies?

do <some statement here, dummy> while (<a condition here, dummy>); It will repeat the statement, and after every repetition checks the condition: if false, leaves to loop.


What is the difference between IF function VLOOKUP function?

The IF function checks a condition to determine a task to do. It is a logical function. VLOOKUP is a lookup function. It can search through a list to find a value or a position in a range, and then find a corresponding value. There are situations where both could be used. Sometimes a VLOOKUP is good for using in place of a nested IF that is having to search through a lot of options. See the related questions below.


What is difference between IF THEN and IF THEN ELSE statement?

An if-then statement, or simply an if statement, checks if a stated condition is true. If the condition is true, then a block of code will then execute. Example: if number equals 3 print out "Number equals 3" An if-then-else statement, or simply an if-else statement, checks if a stated condition is true. If the condition is true, then a certain block of code will then execute. If the condition is false, then a different block of code will then execute. Example: if number equals 3 print out "Number equals 3" else print out "Number does not equal 3" For both if statements and if-else statements, there is only one stated condition. The difference between them is that an if statement will only cause something to happen if the condition is true. An if-else statement will execute a block of code whether the condition is true or false.


What kind of checks are checks which have been paid and returned with your statement?

They are known as cancelled checks as they have been paid.


The function congress is performing when it checks on the programs of the executive branch?

Oversight Function


What statement is true about federalist?

They believed in a system of checks and balances


What is a true statement about the federalists?

They believed in a system of checks and balances


What is the true statement about the federalists?

They believed in a system of checks and balances


When completing a bank statement what do you do with outstanding checks?

Subtract them from the balance.


What is a true statement about federalist?

They believed in a system of checks and balances


The function congresses performing when it checks on the programs of the executive branch?

Oversight Function