Using IF, AND, OR functions

[swhitby]

Hello,

I am trying to create a functions that says:

IF(c2=no) AND(B2= reactive or Ab reactive or unigold) it will return the value of cell a2.

I know how to right if, or, and functions but can you use all 3? Or am I missing another way to do it.

Thanks

 

[Oaktree]

Welcome to the board.

Try =IF(AND(C2="no",OR(B2="reactive",B2="Ab reactive", B2="unigold")),A2,"")

 

[anglais428]

You could omit the AND:
=IF(C2="no",IF(OR(B2="reactive",B2="Ab reactive",B2="unigold"),A2,""),"")

 

[swhitby]

I tried using both formulas but I keep getting an error.

Here is what I'm trying to do: =if(and('Accessioning Worksheet'!E2="no",if(or('Accessioning Worksheet'!D2="reactive",'Accessioning Worksheet'!D2="ab reactive",'Accessioning Worksheet'!D2="unigold +"))),'Accessioning Worksheet'!B2,"")

I keep getting the try not typing a formula error.

 

[swhitby]

Thanks so much I actually figured it out!! But now I need to make a conditional formatting for the same cells. I tried modifying the formula but I can't figure it out

 

[swhitby]

Thanks so much I actually figured it out!! But now I need to make a conditional formatting for the same cells. I tried modifying the formula but I can't figure it out