Excel multiple conditional formulas
 

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

Excel multiple conditional formulas
 

One way..

=IF(A2<3,"",OFFSET(AA50,LOOKUP(A2,{3,4.5,6.5,8.5}, {0,1,2,3}),0,1))

--
Jacob


"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

Excel multiple conditional formulas
 

Try this...

=IF(A2<3,"",INDEX(AA50:AA53,MATCH(A2,{3,4.5,6.5,8. 5})))

--
Biff
Microsoft Excel MVP


"micla252" wrote in message
...
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

Excel multiple conditional formulas
 

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