Question

correct way to write the if function​

Answer 1

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