How to make a cell recognize multiple text strings?

[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",IF(E10:I10="PDX",7.75,IF(E10:I10="MC",7.75,IF(E10:I10="V",7.75,IF(E10:I10="PR",7.75,0)))))))

Any help is welcomed. Thanks.

 

[Biff]

Hi!

You can reduce your formula to a single IF:

=IF(OR(E10={"la","pd","ea","pdx","mc"}),7.75,0)

OR make a list of the text strings in say H1:H5:

Entered as an array with the key combo of CTRL,SHIFT,ENTER:

=IF(OR(E10=H1:H5),7.75,0)

OR, also an array:

=IF(OR(E10:I10=H1:H5),7.75,0)

Biff