How to combine multiple text strings into one "IF" statement???

T

Tourcat

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.75,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",I­F(E10:I10="PDX",7.75,IF(E10:I10="MC",7.75,IF(E10:I10="V",7.7­5,IF(E10:I10="PR",7.75,0)))))))



Any help is welcomed. Thanks.
 
T

tkt_tang

1. Please try =IF(or(E10:I10="LA"),7.75, ......
2. Please visit Pearson's site ; his name is Charles, affectionately
known as Chip.
3. Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make a cell recognize multiple text strings? 1
How to add "IF" statements? 6
If statement conversion from Lotus to Excel2007 6
How to combine 2 different SUMPRODUCT criteria into one cell????? 4
IF statement and Combo Boxes 2
Copying data from one workbook to another dependent on user select 1
Force input in multiple cells in Excel form 8
Prevent user input, if adjacent cell text is identical 6

Top