If Statement with multiple logic / lookup

[Guzzlr]

=IF(B3={"Test 1","Test 2"},$D$3,"N/A")

Hello all,
I'm trying to get the If statement to pull data from D3, if B3 has either "Test 1" or "Test 2" I thought I could use the squiggley's but that doesn't work.
Thanks

 

[Ramballah]

Ever thought of using the OR formula ?

Here u go:
=IF(OR(B3="Test 1",B3="Test 2"),$D$3,"N/A")

 

[AlanY]

try

=IF(or(B3="Test 1",B3="Test 2"),$D$3,"N/A")

 

[Fluff]

With the braces

=IF(OR(B3={"Test 1","Test 2"}),$D$3,"N/A")

 

[Guzzlr]

With the braces

=IF(OR(B3={"Test 1","Test 2"}),$D$3,"N/A")

This is what I was missing with the OR statement, thanks

 

[Fluff]

Your welcome & thanks for the feedback