/how-to-use-absolute-cell-reference-in-excel-4692257-1-31e23755509749058cc7b0e5dce8f3e5.png "in excel continue an equation for many rows in mac")
value_if_false (optional) - the value to be returned if the logical test evaluates to FALSE, i.e. if the condition is met.įor 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_true (optional) - the value to return when the logical test evaluates to TRUE, i.e. In this argument, you can specify a text value, date, number, or any comparison operator.įor example, your logical test can be expressed as or B1="sold", B110. 
logical_test (required) - a value or logical expression that can be either TRUE or FALSE. 
IF(logical_test,, )Īs you see, the IF function has 3 arguments, but only the first one is obligatory, the other two are optional.
0 kommentar(er)
