Formula Override

[osscie3]

I've built a pretty extensive loan pricing model for my boss. Basically you put in some parameters and it does quite a few lookups to determine an interest rate we will charge. Long story short I worked for hours on the formula to get it just right.

Now I want to add in functionality to where if my boss wants to input his own custom interest rate, he can do so. The problem I want to avoid is I don't want the formula to be erased because he basically typed in the exact interest rate he wants.

What's the best way to go about implementing this? I could just put an "Override?" check mark beside it that will allow the formula to be saved once unchecked. But I wanted to get the Excel gods and goddesses opinions before I implement.


Thanks!

 

[Joe4]

One way would be to have an override column on the sheet. If there is a value entered in there, use that, otherwise use the formula.
If that value was in cell A2, the structure of that would look something like this:

[B]=IF(A2<>"",A2,[/B][I]your long formula here[/I][B])[/B]

 

[osscie3]

Worked beautifully. Thanks!

 

[Joe4]

You are welcome!