Copy the formula from cell F2 and paste in all other cells from F3 to F13. In this example we need to select the cell F2 and double click on the bottom right corner. Use IF THEN Excel formula to automate certain Excel functions.
Now press CTRL D simultaneously on your keyboard.
For example to fix the B4 cell use B4 instead. Now press CTRL D simultaneously on your keyboard. B6C2 and press Enter Now select cell C6 and the other cells in the column where you want to apply the formula. Write this formula in cell C2 and drag this formulated cell to the rest of Column C.