| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use a IF(AND) formulae for more than seven conditions
I have 4 variables which give me 34 possible conditions.(A data with 4
columns and 34 rows). The fifth column consists of an answer. I need a formula, which gives me the answer if i enter my four variables. I tried using IF(AND.....) but it can take only seven conditions whereas i have 34 !! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
| Formulae to use for more that 2 conditions criteria | Excel Discussion (Misc queries) | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Threaded Mode
