0
What function in MS Excel which checks the logical condition of a statement?
Wiki User
∙ 8y ago
IF function
Wiki User
∙ 7y ago
Wiki User
∙ 8y agoThe 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.
Add your answer:
Earn +20 pts
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
