I need to make an if then scenario for my job basically to calculate what employees are on attendance warnings and such and I could also hopefully convert same formula for issues into vacation days available and other factors

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

any help would be appreciated hopefully fast because I have to have this done by end the day

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

I actually think I got it working with a lookup

=LOOKUP(B10,{0,24,26,29,32,37,41,47,57,73,94},{0.1 36,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 it on the two scenarios I mentioned above