is there any way to give a result in one cell from the content of other
selected cells.

scenario:
i am trying to create a spreadsheet to work out my current grades for
college. what i am wanting to do is create a function that takes the value
from a selection of cells (ex. B1:B7) and give a result if the content match
a given criteria.
i am looking for something along along the lines of;

cells B1:B7 = x then show result value 1. cells B1:B11 = x then show result
value 2. cells B1:B13 = x then show result 3. (best i can say it as)

my initial through was the IF statement but that failed to give the results.

much appreciated if guidance can be given.