he IF() function performs a logical test
. What is a cell address in Excel? A cell address is used to identify a particular cell on a worksheet. It is denoted by a combination of the respective column letter and a row number. As shown above, the highlighted cell belongs to the column ‘D’ and row 5, so the cell address is read as D5.
Relative cell referencing
Absolute cell referencing
In Relative referencing, there is a change when copying a formula from one cell to another cell with respect to the destination. cells’ address
Meanwhile, there is no change in Absolute cell referencing when a formula is copied, irrespective of the cell’s destination.
This type of referencing is there by default. Relative cell referencing doesn’t require a dollar sign in the formula.
It returns the value in another row/column.
It then returns the value in a left-to-right way.
It returns a value if the test evaluates to true and another value if the test result is false.