Altering a formula based on selection

Wait a second, I think I have found a way around this. Sorry to bother you
all.

"Biff" <biffinpitt@comcast.net> wrote in message
news:OVDE6K0uFHA.3256@TK2MSFTNGP09.phx.gbl...
> Hi!
>
> You need to provide a lot more detail than that!
>
> Biff
>
> "deanfamily11" <deanfamily11@erols.com> wrote in message
> news:uLRVA3zuFHA.2076@TK2MSFTNGP14.phx.gbl...
>> I'd like to be able to change a formula depending on what the selection
>> is. What I want is to have a small list, preferably one that cannot be
>> changed in any way, and when the user selects one choice, it changes the
>> formula in another cell. Any thoughts?
>>
>
>

>Sorry to bother you

No bother at all.

I ("we") love this stuff!

Biff

"deanfamily11" <deanfamily11@erols.com> wrote in message
news:uTpFSQ0uFHA.904@tk2msftngp13.phx.gbl...
> Wait a second, I think I have found a way around this. Sorry to bother
> you
> all.
>
> "Biff" <biffinpitt@comcast.net> wrote in message
> news:OVDE6K0uFHA.3256@TK2MSFTNGP09.phx.gbl...
>> Hi!
>>
>> You need to provide a lot more detail than that!
>>
>> Biff
>>
>> "deanfamily11" <deanfamily11@erols.com> wrote in message
>> news:uLRVA3zuFHA.2076@TK2MSFTNGP14.phx.gbl...
>>> I'd like to be able to change a formula depending on what the selection
>>> is. What I want is to have a small list, preferably one that cannot be
>>> changed in any way, and when the user selects one choice, it changes the
>>> formula in another cell. Any thoughts?
>>>
>>
>>
>
>

What was your way around it?