converting a formula from one cell into its value into a different cell to avoid a circular

There is no such formula. You can accomplish this via a SheetCalculate event sub in VBA. Here is a good primer: https://trumpexcel.com/vba-events/