Question

returns true if condition is false and vice versa. Fill in the blanks
​

Answer 1

Answer:

logical_test (required) - a value or logical expression that can be either TRUE or FALSE. In this argument, you can specify a text value, date, number, or any comparison operator.

For example, your logical test can be expressed as or B1="sold", B1<12/1/2014, B1=10 or B1>10.

value_if_true (optional) - the value to return when the logical test evaluates to TRUE, i.e. if the condition is met.

For example, the following formula will return the text "Good" if a value in cell B1 is greater than 10: =IF(B1>10, "Good")

value_if_false (optional) - the value to be returned if the logical test evaluates to FALSE, i.e. if the condition is not met.

For example, if you add "Bad" as the third parameter to the above formula, it will return the text "Good" if a value in cell B1 is greater than 10, otherwise, it will return "Bad":

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