Any better solution than awkward nested if?

[dayanday]

I wrote a nested if to add a description based on a column's value, like this:

=IF(A2<0,"No Activity", IF(A2>180,"No Activity More than 180 days", IF(A2>150,"Within 180",IF(A2>120,"Within 150",IF(A2>90,"Within 120","Within 90")))))

It's a little awkward, I wonder if there's any other neat method? Thanks.

 

[Smitty]

Welcome to the Board!

I'd suggest a Lookup table.

 

[dayanday]

Welcome to the Board!

I'd suggest a Lookup table.

Thanks, it's way much better.

 

[GerryZ]

Mybe:

Book1
	A	B	C	D	E
1	Table			criteria	Result
2	<0	No Activity		>90	Within 120
3		Within 90
4	>90	Within 120
5	>120	Within 150
6	>150	Within 180
7	>180	No Activity more than 180 days
Foglio2

Cell Formulas
Range	Formula
E2	=VLOOKUP(D2,A2:B7,2,0)