Help with formula

[mazher]

Hi,

I am using this formula

=IF(E2<=0,"Expired",IF(E2<=7,"1 Weeks Left",IF(E2<=14,"2 Weeks Left",IF(E2<=21,"3 Weeks Left",IF(E2<=30,"4 Weeks Left",IF(E2<=60,"2 Months Left","More Than 3 Month"))))))

e2<= 0 its expired
e2 = 1 to 6 than "Less than a week"
e2 = 7 to 13 then "Less than 2 weeks"
e2= 14 to 20 then "Less than 3 weeks
e2= 21 to 31 then "Less than month"
e2= 32 to 60 then "Less than 2 months"
e2= 61 to 90 "Less than 3 months"

else " More than 3 Months


Can some one help me constructing this =if() or some better approach.

Regards

Mazher

 

[mazher]

Thnaks T. Valko

It was simple and it worked like a charm.

MaZhEr

 

[T. Valko]

Thnaks T. Valko

It was simple and it worked like a charm.

MaZhEr

You're welcome. Thanks for the feedback!