If formula copied down

I have the attached spreadsheet and in column L in contains a very simple If formula. I have copied it down but is there a way I can use VBA to put the formula in automatically. I wouldn’t want to have to press a button for it to then enter the formulas, I would want excel to do it automatically as soon as data is put in column C

The code would need to find the last cell that contains data.