9. Use the IF function to check cells in worksheets and workbooks
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
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.
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
No comments:
Post a Comment