correct way to write the if function
Answers
Answer:
The correct answer to the question -"correct way to write the if function" is-
Explanation:
IF function
In Excel, the IF function performs a logical comparison between two values. IF function gives the result which is either TRUE or FALSE.
For example -we can test whether the value in cell B3 is smaller than the value in cell A3. If yes, the result is TRUE, if no, the result is FALSE.
Writing an if statement
This, if statement is written with if keyword, which is followed by a condition which is in parentheses, where the code is to be executed within curly brackets.
That means, it can be written as if () or {} .
Writing an if in formula
When we combine formula with each one of them with an IF statement, it seems like this,
AND – =IF(AND(Something is True, Something else is True), Value if True, Value if False)
OR – =IF(OR(Something is True, Something else is True), Value if True, Value if False)
NOT – =IF(NOT(Something is True), Value if True, Value if False)
Syntax-
We use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false.
For example:
=IF(A2>B2,"Over Budget","OK")
To know more about internet explorer click on the link below-
https://brainly.in/question/8140316
To know more about windows explorer click on the link below-
https://brainly.in/question/5717026