Use the IF function, one of the logical functions, to return one value if a condition is true and another value if its false. For example: =IF(A2>B2,Over Budget,OK) =IF(A2=B2,B4-A4,)

Use nested functions in a formulaClick the cell in which you want to enter the formula.To start the formula with the function, click Insert Function on the formula bar . In the Or select a category box, select All. To enter another function as an argument, enter the function in the argument box that you want.

As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet. It is possible to nest multiple IF functions within one Excel formula. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.

Use the IF function, one of the logical functions, to return one value if a condition is true and another value if its false. IF(logical_test, value_if_true, [value_if_false]) For example: =IF(A2>B2,Over Budget,OK) =IF(A2=B2,B4-A4,)

2:063:51Excel - Multiple Formulas In The Same Cell - YouTubeYouTube