| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to make a cell recognize multiple text strings?
Because a cell can only have 7 "IF" statements, is there a way to
combine multiple text strings into one "IF" statement? Here is what I have for cell H24: =IF(E10="LA",7.75,IF(E10="PD",7.75,IF(E10="EA",7.7 5,IF(E10="PDX",7.75,IF(E10="MC",7.75,IF(E10="V",7. 75,IF(E10="PR",7.75,0))))))) The problem is that I need to have the same criteria for cells E10:I10 in the same cell H24. I have tried this but it doesn't work: =IF(E10:I10="LA",7.75,IF(E10:I10="PD",7.75,IF(E10: I10="EA",IF(E10:I10="PDX",7.75,IF(E10:I10="MC",7.7 5,IF(E10:I10="V",7.75,IF(E10:I10="PR",7.75,0)))))) ) Any help is welcomed. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions | |||
| How can I make Excel Files save as the text appers in a cell, can. | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| how to hyperlink text to a cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
