Need to calculate average if values fall into EITHER range.

I have two ranges that can be met.

If value falls into EITHER one of those ranges I want to to calculate the average, if it doesnt fit into either one then i want to display not in range.

I also want to determine either A or B based on what range it falls under.

Pretty much i want to label something A if it falls into range 1 or label it b if it falls into range 2, and display "no good" if it doesnt fall into either range.

I dont know if im conveying my issue properly. Any help would be appreciated.