Question

are input to functions, which accept values as number or text





guys please answer​

Answer 1

Answer:

Arguments are input to function which accept values as number or text. A function must 6 be followed by opening and closing parenthesis.

Explanation:

Answer 2

Answer:

If value_if_false is omitted

If you don't care what happens when the specified condition is not met, you can omit the 3rd parameter in your formulas, which will result in the following.

If the logical test evaluates to FALSE and the value_if_false parameter is omitted (there is just a closing bracket after the value_if_true argument), the IF function returns the logical value FALSE. It's a bit unexpected, isn't it? Here is an example of such a formula:

=IF(B1>10, "Good")

Putting a comma after the value_if_true argument forces your IF statement to return 0, which doesn't make much sense either:

=IF(B1>10, "Good",)

And again, the most reasonable approach is to put "" in the third argument, in this case you will have empty cells when the condition is not met:

=IF(B1>10, "Good", "")

IF formulas with the value_if_false argument omitted

Get the IF function to display logical values TRUE or FALSE

For your Excel IF formula to display the logical values TRUE and FALSE when the specified condition is met and not met, respectively, type TRUE in the value_if_true argument. The value_if_false parameter can be FALSE or omitted. Here's a formula example:

=IF(B1>10, TRUE, FALSE)

or

=IF(B1>10, TRUE)

an example of the IF function that displays logical values TRUE or FALSE