conditions in Excel
Hi
some questions:
- do you want a worksheet formula or a VBA solution?
- your first and second condition are identical but you want different
results?
--
Regards
Frank Kabel
Frankfurt, Germany
farsta_online wrote:
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
|