Now you will get the A1 cell value of previous worksheet Sheet2 in current worksheet. The SHEET function includes hidden sheets in the numbering sequence. The IF function is used to run a logical test and react differently depending on whether the result is TRUE or FALSE.
When we use a reference to a cell on the current sheet we just type in the name or select it using the mouse.
So in order to reference an excel cell or range of cells from another sheet we need to get a worksheet name first ie Sheet1 and followed by an exclamation mark before we mention the cell address and cell address is B2. In the case of a single-cell worksheet name and. Now you will get the A1 cell value of previous worksheet Sheet2 in current worksheet. The result from IF can be a value a cell reference or even another formula.