I need a formula that can perform four possible evaluations in a cell and
return one of four possible answers.
Something like this:

If a23 or a2<4.5 return value from aa50
If a24.5 or a2<6.5 return value from aa51
If a26.5 or a2<8.5 return value fron aa52
If a28.5 return value from aa53

Any help would be greatly appreciated