Hi all,

I was wondering if there was a function or macro which allows you to lock part of a formula in a cell, and then any number you input in the cell will be subject to that frozen formula part. For example, you know that one row will always take a manually-inputted number and divide that number by 2. Is there a way to lock "X/2" and then the manually-inputted number would become "X"?

I know technically I can just separate out this process into two rows, but I need to conserve space and wanted to consolidate it into one row. Thanks, I hope this was not too confusing.