If, And formula

[aedislee]

Hi all

I have a range of values from 1 to 1800

I want a formula that sayd if the values is between 1-180 then OK, 180-365 is 1 Year, 366-730 then 2 years etc etc

Cant get it too work

help appreciated

thanks

[6StringJazzer]

Try this:

Please Login or Register  to view this content.

[Tony Valko]

Create a table like this:

Data Range

	D	E	F
1	From	To	Value
2	1	180	OK
3	181	365	1
4	366	730	2

Then, assuming cell A1 contains a number, enter this formula in B1:

=LOOKUP(A1,D2:F4)

[Jonmo1]

Try

=LOOKUP(A1,{1,181,166,731},{"OK","1 Year","2 Years","etc"})