Help with an if then scenario

[iVassh]

I need to make an if then scenario for my job basically to calculat
what employees are on attendance warnings and such and I could als
hopefully convert same formula for issues into vacation days availabl
and other factor

what I need is if cell a1 is between 0-5 then cell b1 will show LVL0 i
cell a1 is between 5-6 then cell b1 will show LVL1 and so on fo
attendance occurrences

and for vacation time if cell a2 is between 0-7.99 cell b2 will show "0
if cell a2 is between 8-15.99 cell b2 will show "1 day" and so o

any help would be appreciated hopefully fast because I have to have thi
done by end the da

 

[Claus Busch]

Hi,

Am Fri, 3 May 2013 09:28:01 +0100 schrieb iVassh:

what I need is if cell a1 is between 0-5 then cell b1 will show LVL0 if
cell a1 is between 5-6 then cell b1 will show LVL1 and so on for
attendance occurrences

and for vacation time if cell a2 is between 0-7.99 cell b2 will show "0"
if cell a2 is between 8-15.99 cell b2 will show "1 day" and so on

in B1 try:
="LVL"&IF(A1<5,0,CHOOSE(ROUNDUP(A1-5,0),1,2,3,4,5,6,7,8,9,10))
and in B2:
=IF(A2<8,0,CHOOSE(ROUNDDOWN(A2/8,0),1,2,3,4,5,6,7,8,9,10)&" day(s)")


Regards
Claus Busch

 

[iVassh]

Hi,

Am Fri, 3 May 2013 09:28:01 +0100 schrieb iVassh:
-

in B1 try:
="LVL"&IF(A1<5,0,CHOOSE(ROUNDUP(A1-5,0),1,2,3,4,5,6,7,8,9,10))
and in B2:
=IF(A2<8,0,CHOOSE(ROUNDDOWN(A2/8,0),1,2,3,4,5,6,7,8,9,10)&" day(s)")


Regards
Claus Busch

I actually think I got it working with a lookup

=LOOKUP(B10,{0,24,26,29,32,37,41,47,57,73,94},{0.136,0.133,0.13,0.127,0.124,0.121,0.119,0.116,0.113,0.11,0.107})

that's a different thing im working on but It should work when I try i
on the two scenarios I mentioned abov