FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Select the output cell, and use the following formula: =IF(cell<>"", value to return, “"). For our example, the cell we want to check is A2, and the return value will be No. In this scenario, you’d change the formula to =IF(A2<>"", “No", “").

Detailed explanation-2: -The IF function checks whether a condition is TRUE or FALSE, and then returns one value if the condition is TRUE, and another value if the condition is FALSE. In this case, we want to return the original cell value if the condition is FALSE. This formula will test whether the value in cell A1 is equal to 1.

Detailed explanation-3: -Syntax. 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")

Detailed explanation-4: -In Excel, you can use the VLOOKUP function to quickly show value based on the corresponding value. D1 is the value you look up based on, A1:B7 is the data range you look for, 2 indicates to find the value in second column of the looking for range. Press Enter key, the value is displayed.

Detailed explanation-5: -The syntax of IF-THEN is =IF(logic test, value if true, value if false). The first argument tells the function what to do if the comparison is true. The second argument tells the function what to do if the comparison is false.