| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement help
I have a formula that won't let me enter in any more if statements. Can you
help This is what I have: =IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10 ,V10,"")))) I have 8 of these if statements in the one cell and it won't let me put in any more. Is there a different formula that I can use or modify this one? Thanks!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement help
Try it like this:
=IF(COUNTIF(P7:P14,D19),INDEX(V7:V14,MATCH(D19,P7: P14,0)),"") Biff "ack" wrote in message ... I have a formula that won't let me enter in any more if statements. Can you help This is what I have: =IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10 ,V10,"")))) I have 8 of these if statements in the one cell and it won't let me put in any more. Is there a different formula that I can use or modify this one? Thanks!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement help
Guessing from the pattern ...
=IF(ISNA(VLOOKUP(D19,P7:V18,7,0)),"", VLOOKUP(D19,P7:V18,7,0)) ?? "ack" wrote: I have a formula that won't let me enter in any more if statements. Can you help This is what I have: =IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10 ,V10,"")))) I have 8 of these if statements in the one cell and it won't let me put in any more. Is there a different formula that I can use or modify this one? Thanks!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement help
guessing also from the pattern,
=IF(D19=P7:P14,V7:V14,"") *array* entered with ctrl+shft+ent. regards, driller -- ***** birds of the same feather flock together.. "ack" wrote: I have a formula that won't let me enter in any more if statements. Can you help This is what I have: =IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10 ,V10,"")))) I have 8 of these if statements in the one cell and it won't let me put in any more. Is there a different formula that I can use or modify this one? Thanks!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement help
Not sure what you're thinking but that won't work.
Biff "driller" wrote in message ... guessing also from the pattern, =IF(D19=P7:P14,V7:V14,"") *array* entered with ctrl+shft+ent. regards, driller -- ***** birds of the same feather flock together.. "ack" wrote: I have a formula that won't let me enter in any more if statements. Can you help This is what I have: =IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10 ,V10,"")))) I have 8 of these if statements in the one cell and it won't let me put in any more. Is there a different formula that I can use or modify this one? Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| Help with an IF statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
