Override a Formula

Is there any simple way to override a formula in a specific cell?

A video is worth 1000 words!

Thank you that’s awesome!