Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditions in Excel
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for excel msg pop up when certain conditions are met | Excel Discussion (Misc queries) | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |