Or...........

=LOOKUP(N5,{0,3,9,16,22},{"",1,2,3,"Exceeds limit"})

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

> Maybe this..........
>
> =IF(N5>2,LOOKUP(N5,{3,9,16,22},{1,2,3,"Exceeds limit"}),"")
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "helpmeplease" wrote:
>
> > I have a nubmer of days that needs to fall into a certain week number for
> > pricing calculations. If the number of days is 3:8 then it is 1 week; 9:15
> > is 2 weeks; and 16:21 is 3 weeks. Right now the function is able to
> > correctly calculate week 1 and week 2. If I try to insert the week 3
> > function, I get an error that there are too many arguments. "N5" is the cell
> > with the number of days. I'm not very advanced with excel (it took me all
> > morning to get this far), so I would appreciate any help. Thanks!!
> >
> > =IF(N5<9,IF(N5>2,1,0),IF(N5<16,IF(N5>8,2,0),0))