Hi,
I need help with conditions:

How do I write the content of cell B9:
1)A20 AND B20
if true: B9 = c
if False: B9 = d

2) A20 or B20
if true: B9 = e
if False: B9 = f

3) A2 = g AND B2 = h AND C2 = i
if true: B9 = j
if False: B9 = k

4) A2 = l OR B2 = m OR C2 = n
if true: B9 = o
if False: B9 = p

Any answer willbe appriceated
Peter