CHOOSE function -

[oneandtwo]

Hello,

I am having one problem. I am using three cells all together. My problem is I don't know how to create correct Choose function.

For now I am using this one:

Please Login or Register  to view this content.

Excell is offering me three solutions: AC, BC, or blank cell. But I would like to configure formula as well, it would offer me a solution A or B only, when I9 cell is not filled with C. For now as I said, it offers me blank cell in alternative, which is not what I would like to have.

My ideal solutions would be: AC or BC or A or B. Can you help?

I would appreciate your help very much.

[daffodil11]

I'm not quite sure I understand what you're trying to do.

CHOOSE simply tells Excel which option to choose.

=CHOOSE(2,OPTION #1 IF(E9<10,"A","B"),OPTION #2 IF(I9="C","C",""))

You're telling it to choose OPTION #2. IF(I9 = "C", output "C", otherwise do nothing)

My I9 is blank. It does not = "C". My cell comes up empty as well, because I9 is not the letter C.