Help - got a little lost with a formula solution and now confused!

Hi there, am sure this will be easy for the community but your help would be a life saver after going around the houses with my feeble attempts.  Ok so here it is:-   I have a blank column which is...