Code:
=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
=IF(B3={"Test 1","Test 2"},$D$3,"N/A")
With the bracesCode:=IF(OR(B3={"Test 1","Test 2"}),$D$3,"N/A")