Can we promote a particular cell value to a formula in Excel?

Answer 1

Sure, just add an equal sign.

Formula always begins with the equal sign.

Now, creating the formula that correctly calculates the value is a different problem

in and of itself. You must understand how the value is calculated