I have seen formulas entered as plain text in a cell, and then a macro used to update other cells with that formula. You can then change the formula in one plac

I have seen formulas entered as plain text in a cell, and then a macro used to update other cells with that formula. You can then change the formula in one place and run the macro to update it everywhere.