Altering a formula based on selection

[deanfamily11]

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?

[Biff]

Hi!

You need to provide a lot more detail than that!

Biff

"deanfamily11" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[deanfamily11]

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

"Biff" <[email protected]> wrote in message
news:[email protected]...
> Hi!
>
> You need to provide a lot more detail than that!
>
> Biff
>
> "deanfamily11" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>
>

[Biff]

>Sorry to bother you

No bother at all.

I ("we") love this stuff!

Biff

"deanfamily11" <[email protected]> wrote in message
news:[email protected]...
> Wait a second, I think I have found a way around this. Sorry to bother
> you
> all.
>
> "Biff" <[email protected]> wrote in message
> news:[email protected]...
>> Hi!
>>
>> You need to provide a lot more detail than that!
>>
>> Biff
>>
>> "deanfamily11" <[email protected]> wrote in message
>> news:[email protected]...
>>> 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?
>>>
>>
>>
>
>

[BlueDaze]

What was your way around it?