Hi,

I'm trying to create a formula using an IF statement.

If a another cell contains a particular value then I want the user to
be able to pick from two values to go into the current cell.

Is this possible with an IF statement?

Thanks.

It depends. Can you turn the user's decision of which of the two values to
choose into a logical decision, i.e., under condition1 choose one value and
under condition2 choose another value? If so, then what you want to do can
be accomplished with a nested If.

"Gary" wrote:

Hi,

I'm trying to create a formula using an IF statement.

If a another cell contains a particular value then I want the user to
be able to pick from two values to go into the current cell.

Is this possible with an IF statement?

Thanks.

Maybe you could use Data|Validation with a dependent list:

Debra Dalgleish has notes:
http://www.contextures.com/xlDataVal02.html

Gary wrote:

Hi,

I'm trying to create a formula using an IF statement.

If a another cell contains a particular value then I want the user to
be able to pick from two values to go into the current cell.

Is this possible with an IF statement?

Thanks.

--

Dave Peterson