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.