Split is correct. Locking a cell only stops a user from changing it. It doesn't inhibit the formulas IN the cell from working/changing/whatever it is designed to do.