I need an if function that would return the number of days below

If cell a1=32 hours =3.5 days
Range:
1-10= 1day
11-14=1.5 days
15-20=2 days
21-24= 2.5 days
25-30=3 days
31-34= 3.5 days
35-40= 4 days

=LOOKUP(G2,{1,11,15,21,25,31,35},{1,1.5,2,2.5,3,3. 5,4})

Do note that your ranges are not equal.
11-14 covers 4 hours, while
15-20 covers 6 hours.

The lookup works by defining the lower limit of each section.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"LaTanya" wrote:

I need an if function that would return the number of days below

If cell a1=32 hours =3.5 days
Range:
1-10= 1day
11-14=1.5 days
15-20=2 days
21-24= 2.5 days
25-30=3 days
31-34= 3.5 days
35-40= 4 days

Hi,

If i've understood correctly, try this

=LOOKUP(A1,{1,11,15,21,25,31,35},{"1 day","1.5 days","2 Days","2.5 Days","3
Days","3.5 Days","4 Days"})

Mike

"LaTanya" wrote:

I need an if function that would return the number of days below

If cell a1=32 hours =3.5 days
Range:
1-10= 1day
11-14=1.5 days
15-20=2 days
21-24= 2.5 days
25-30=3 days
31-34= 3.5 days
35-40= 4 days

=MAX(1,CEILING(A1+IF(MOD(A1,10)=0,0,0.1),5)/10) & " day(s)"

If this post helps click Yes
---------------
Jacob Skaria


"LaTanya" wrote:

I need an if function that would return the number of days below

If cell a1=32 hours =3.5 days
Range:
1-10= 1day
11-14=1.5 days
15-20=2 days
21-24= 2.5 days
25-30=3 days
31-34= 3.5 days
35-40= 4 days

Hi,

In range B3:D9, enter the range I.e. in range B3:B9 enter the lower limits,
in range C3:C9, enter the upper limits and in D3:D9 enter the days. In cell
B1, you may use the following formula

=vlookup(A1,B3:D9,3)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LaTanya" wrote in message
...
I need an if function that would return the number of days below

If cell a1=32 hours =3.5 days
Range:
1-10= 1day
11-14=1.5 days
15-20=2 days
21-24= 2.5 days
25-30=3 days
31-34= 3.5 days
35-40= 4 days