"IF" formula help

[Benk87]

Hi All,


I think I'm looking for an 'IF' formula which achieves the following "IF" cell1 contains "200"or"300" populate cell2 with the same value.

Thanks in advance.

 

[JeanRene]

Try this

=IF(OR(A1=200,A1=300),A1,"")

 

[Caribeiro77]

Hi and welcome to the board:

In cell 2 try:

=IF(OR(cell1=200;cell1=300),cell1)

and i don't know what you need if it's not but if you want a blank:

=IF(OR(cell1=200;cell1=300),cell1,"")

 

[VoG]

Maybe like this

=IF(OR(A1=200,A1=300),A1,"")

 

[Stridhan]

In cell2

=IF(OR(cell1=200,cell1=300),cell1,"")

 

[Benk87]

Thanks for your warm welcome guys, the comments are much appreciated.

I think we're on the right track, however I should clarify that "cell1" will have other values in besides "200" / "300" so the formula will need a 'SEARCH' incorporated which picks out the "200" or "300" from the string and then returns "200" or "300" in cell2 respectively. I hope this makes sense.

Thanks again guys

 

[Benk87]

the "other" values will be text, I should clarify that.

 

[Caribeiro77]

Can you post some examples?

 

[Benk87]

Thanks for taking a look.

An example of cell1 data is "xxxx200" or "xxxx300" or "xxxx"
so I think I'm looking for an 'IF' formula which does the following:

IF cell1 contains a string of "200" or "300", populate cell2 with "200" or "300" (whichever is found).
However If cell1 does not contain any of the above strings, populate "cell2" as 0

 

[JeanRene]

Try this
=IF(OR((RIGHT(A1,3)*1)=200,((RIGHT(A1,3)*1)=300)),RIGHT(A1,3),0)