IF FUNCTION

[JUAN]

Hi,
question, trying to do an if statment but doens't seem to
work. I did the function in excel.
Example
Col A COL B
BC1 formula here
BC2

This is what I put =IF(A2=BC1,"BC DIV", "UNKNOWN") but I
get UNKNOWN, but looking at A2 it does equal to BC1. When
I put a number in A2 and I change formula and put a number
it does work. So Does the Function just work with numbers
or also with words?

Any help would be helpful.
thanks,
Juan

 

[Frank Kabel]

Hi
just a small error You're trying to compare cell A2 with the CELL
BC1 (and not with the value 'BC1'). Try
=IF(A2="BC1","BC DIV", "UNKNOWN")
and it should work

 

[juan]

Hi Frank,
thanks. Question
Let said I have in column A
BC1
BC2
BC3
BC4
etc
and maybe some go to same place can I do this? Can
something like IF(A:A=BC1 OR BC3 OR BC4, "BC DIV","UNKNONW"
HOpe I'm explaining it right. My column might have 56
different groups, but some might not fall with the same
group.

Please advise any suggestions.
Thanks,

Juan

 

[Frank Kabel]

Hi
try
=IF(COUNTIF(A:A,"BC*")>0,"BC DIV","Unknown")