Hi there. Is there anyway to do something like conditional formatting but instead of changing a cell's format it would change the cell's contents?

I build financial models for clients and have always gone to the IF statement in these situations [for example... =IF(F23="--",0,(G10^F10)/F4) ]. The bottleneck [and there's always a bottleneck] is that I need to edit the cell formula everytime I change one component of said formula.

What I'd like to do is to have the ability to simply copy and paste a value [any value or formula] into a cell and have an overarching tool [like conditional formatting] that will place a zero [0] into that same cell anytime some other condition is met.

Thanks a ton for any help!