View Single Post
  #1   Report Post  
Tourcat
 
Posts: n/a
Default 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.