The formula is working perfectly.Ģ) Using Excel Fill Handle Tool (Dragging) I select cell reference D8 and press the F2 key (this takes the cell to Edit mode) on the keyboard.
And when we shall copy this formula down, the references will be C2, C2, C2, C2, and C2. Because the reference of column C is relative.