View Single Post
  #1   Report Post  
iVassh iVassh is offline
Junior Member
 
Posts: 3
Default Help with an if then scenario

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

Last edited by iVassh : May 3rd 13 at 09:34 AM