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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2