Altering a formula based on selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deanfamily11 - 17 Sep 2005 05:10 GMT

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?

Reply to this Message

Biff - 17 Sep 2005 05:46 GMT

Hi!

You need to provide a lot more detail than that!

Biff

> 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?

Reply to this Message

deanfamily11 - 17 Sep 2005 05:55 GMT

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

> Hi!
>
[quoted text clipped - 6 lines]
>> changed in any way, and when the user selects one choice, it changes the
>> formula in another cell. Any thoughts?

Reply to this Message

Biff - 17 Sep 2005 06:51 GMT

>Sorry to bother you

No bother at all.

I ("we") love this stuff!

Biff

> Wait a second, I think I have found a way around this. Sorry to bother
> you
[quoted text clipped - 10 lines]
>>> changed in any way, and when the user selects one choice, it changes the
>>> formula in another cell. Any thoughts?

Reply to this Message

BlueDaze - 22 Sep 2005 09:00 GMT

What was your way around it?

Signature

BlueDaze

Reply to this Message