ANDIF Formula

[mikeywhits]

Hi all,

I have 3 cells A1, B1, C1

Cell A1 will either be blank or "R".
Cell B1 will either be blank or "A".
Cell C1 will either be blank or "G".

When 1 cell has a letter the other 2 cell are always blank.
Is there anyway of creating an ANDIF formula (i assume), which will capture only the cell with a letter in?

Thanks,

 

[Jonmo1]

If this is a true statement...

When 1 cell has a letter the other 2 cell are always blank.

Then try

=LOOKUP("Z",A1:C1)

This will error if All 3 cells are blank...
To correct for that try

=LOOKUP("Z",CHOOSE({1,2},"",A1:C1))

 

[taurean]

You can use Data Validation for forcing user to enter only desired data.

The second part, I did not understand but if you want to check - if the data is fed in one cell then others are blank then in cell D1 insert a formula like:

=IF(COUNTA(A1:C1)>1,"CHECK","OK")

 

[Ruddles]

Isn't it just:-

=A1&B1&C1

?

 

[mikeywhits]

Hi Guys,

Tried the LOOKUP("Z") and does exactly what i need.

Appreciate all your help.

 

[T. Valko]

=LOOKUP("Z",A1:C1)

But, but, but....we must use BigString?

 

[Jonmo1]

But, but, but....we must use BigString?

Oooh, my own stalker...

 

[mikeywhits]

Not sure what Big String means,

But as i do the formula it only finds data in row C, this being "G",

Rows A & B seem to get ignored?

 

[T. Valko]

Not sure what Big String means,

Sorry, that's an inside joke.

 

[Jonmo1]

Not sure what Big String means,

But as i do the formula it only finds data in row C, this being "G",

Rows A & B seem to get ignored?

Yep, it was an inside joke.

Stick to "Z", As long as your original post was your actual need, and not a "dummed down" version of something more complicated.