FUNDAMENTALS OF COMPUTER

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

Detailed explanation-2: -If you clicked IF, the Function arguments dialog box displays the arguments for the IF function. To nest another function, you can enter it into the argument box. For example, you could enter SUM(G2:G5) in the Value if true box of the IF function. Enter any additional arguments that are needed to complete your formula.

Detailed explanation-3: -Multiple formulas in one cell are not allowed, but built-in functions and nesting can be used to express a series of calculations and logical operations in a single formula. Using standard functions, you can build complex formulas that handle a variety of conditions.

Detailed explanation-4: -To check if a cell contains text, select the output cell, and use the following formula: =IF(ISTEXT(cell), value to return, “"). For our example, the cell we want to check is A2, and the return value will be Yes. In this scenario, you’d change the formula to =IF(ISTEXT(A2), “Yes", “").