Is the goal to ultimately get column C correctly filled with the values?

If so, try highlighiting column C and press CTRL + G
Click Special
Select Blanks
Click OK (DO NOT PRESS ENTER)
Press =
Press DOWN Arrow Key
Press CTRL + ENTER