USE THE IF FUNCTION TO CHECK CELLS IN WORKSHEETS AND WORKBOOKS USING MICROSOFT EXCEL

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").

USE THE IF FUNCTION TO CHECK CELLS IN WORKSHEETS AND WORKBOOKS USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, Use the IF function to check cells in worksheets and workbooks using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel