| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting more than 7 conditions?
What is an easier way when you have to nest more than seven conditions,
example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm typing in the formula to input the information from the cell directly above from the cell that meets the condition. Does that make sense? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting more than 7 conditions?
Look at Index/Match
=INDEX(D7:F7,MATCH(W8,D8:F8,0)) Adjust the ranges as necessary: "Gina" wrote: What is an easier way when you have to nest more than seven conditions, example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm typing in the formula to input the information from the cell directly above from the cell that meets the condition. Does that make sense? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting more than 7 conditions?
If the formula is in say D8, why not just use
=D7 If you copy it elsewhere, it will adjust. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gina" wrote in message ... What is an easier way when you have to nest more than seven conditions, example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm typing in the formula to input the information from the cell directly above from the cell that meets the condition. Does that make sense? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting more than 7 conditions?
Maybe this will work
=INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0)) to make it dodge errors =IF(ISNUMBER(MATCH($W$8,$D$8:$V$8,0)),INDEX($D$7:$ V$7,MATCH($W$8,$D$8:$V$8,0)),"no Match") -- Regards, Peo Sjoblom Portland, Oregon "Gina" wrote in message ... What is an easier way when you have to nest more than seven conditions, example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm typing in the formula to input the information from the cell directly above from the cell that meets the condition. Does that make sense? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting more than 7 conditions?
Thank you so much, it works!
"Peo Sjoblom" wrote: Maybe this will work =INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0)) to make it dodge errors =IF(ISNUMBER(MATCH($W$8,$D$8:$V$8,0)),INDEX($D$7:$ V$7,MATCH($W$8,$D$8:$V$8,0)),"no Match") -- Regards, Peo Sjoblom Portland, Oregon "Gina" wrote in message ... What is an easier way when you have to nest more than seven conditions, example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm typing in the formula to input the information from the cell directly above from the cell that meets the condition. Does that make sense? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nesting more than 7 conditions?
Thanks for the feedback
-- Regards, Peo Sjoblom Portland, Oregon "Gina" wrote in message ... Thank you so much, it works! "Peo Sjoblom" wrote: Maybe this will work =INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0)) to make it dodge errors =IF(ISNUMBER(MATCH($W$8,$D$8:$V$8,0)),INDEX($D$7:$ V$7,MATCH($W$8,$D$8:$V$8,0)),"no Match") -- Regards, Peo Sjoblom Portland, Oregon "Gina" wrote in message ... What is an easier way when you have to nest more than seven conditions, example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm typing in the formula to input the information from the cell directly above from the cell that meets the condition. Does that make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
| How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| nesting sum if and | Excel Worksheet Functions | |||
| Nesting If Statement with "AND", "OR" conditions | Excel Worksheet Functions | |||
Linear Mode
