How to Output Data into Another Column in Excel Without Recalculation

Hey y'all. Could someone explain how to get an output into another column without having to run the whole column again. As you can see in the screenshot the output worked in the top rows but not on the subsequent rows. Any help would be really appreciated