Multiple IF, AND & OR Formula - Help Needed.

[Retsu]

I'm struggling to write a working formula that contains all the arguments below to return the correct result.

IF D3 = "4" OR "8" AND G3 = "1" then "8DM11"
IF D3 = "4" OR "8" AND G3 = "2" then "8DM21"
IF D3 = "A" AND G3 = "1" then "8DM11"
IF D3 = "A" AND G3 = "2" then "10NM1"

Any help on this would be appreciated.

Taylor

 

[Retsu]

Spot on.

I appreciate the time you've spent looking into this for me, you've been a massive help.