| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nested if(and(or)) function?
I need a formula that does the following. Is this possible?(complete noob!)
If no numbers match "SINGLE"..If two numbers match "DOUBLE"…If three numbers match "TRIPLE"… All four numbers match "QUAD" Also, each number is in a separate cell. 7 4 2 7 DOUBLE 1 9 6 7 SINGLE 2 3 0 1 SINGLE 8 7 8 2 DOUBLE 3 6 5 9 SINGLE 2 7 7 7 TRIPLE 9 9 7 9 TRIPLE 3 4 0 4 DOUBLE 1 1 7 6 DOUBLE 7 9 5 3 SINGLE 1 1 1 1 QUAD Last edited by budward : December 8th 08 at 01:55 AM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Function | Excel Discussion (Misc queries) | |||
| can you nested sum and round function within if function? | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Nested "If" Function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
