=IF(logical_test, value_if_true, value_if_false)
- logical_test = Any value or expression that can be evaluated to TRUE or FALSE. (e.g. cell A1>10)
- value_if_true = The value (or formula) that you want to be returned (or calculated) if the logical_test argument evaluates to TRUE.
- value_if_false = The value (or formula) that you want to be returned (or calculated) if the logical_test argument evaluates to FALSE.
Tag: arguments, complex, dirty, easy, efficiency, EXCEL, FALSE, fast, finance, formula, function, functions, help, if, increase, index, management, manipulation, marketing, match, microsoft, productivity, quick, reports, simple, speed, spreadsheet, summary, THEN, tip, trianing, trick, TRUE, tutorial, video, vlookup