In cells z50:z53 insert 3, 4.5, 6.5 and 8.5
Your values are in aa50:aa53

Then, supposing your numbers are in Column A, apply the following formula in
B1 and copy down:
=VLOOKUP(A1,$Z$50:$AA$53,2,1)
--
Thanx & Best Regards,

Faraz!


"micla252" wrote:

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