Use the IF function to check cells in worksheets and workbooks - Logical Functions - Microsoft Excel Tutorials

9.  Use the IF function to check cells in worksheets and workbooks

To use an IF statement not only in a worksheet but also in a linked worksheet or workbook, start typing part of the formula, for example, “ =IF(,” then navigate to another worksheet or open up a workbook, select the desired cell, and go back to the first worksheet to finish the formula.

To use the IF function to check out cells in another worksheet:

Type =IF(Sheet8!A2"january","wrong month","OK").

To use the IF function to check out cells in another workbook:

Type =IF('C:\Held\Formulas\Files\[Formulas.xls]Sheet35'!$A$1<>1,"wrong","OK").

Watch the Video Tutorial - https://www.youtube.com/watch?v=1tTcyhSnXzU

Hope You Like This Tutorials - Give Comments