| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup or IF statement
Thanks Akphidelt, great solution works great
Jenny "akphidelt" wrote: Alright, sorry about this, but I felt a little bad about the code and actually tried it out. It does work except if a value is 15, it will select 16-20 years. So to correct that, use this equation instead and you should be good =IF((A1/5)<1,"1 - 5 years",IF(MOD(A1/5,1)=0,A1/5*5-4&" - "&INT(A1/5)*5&" years",INT(A1/5)*5+1&" - "&INT(A1/5)*5+5&" years")) "GuinnessT" wrote: Hi, I want to assign a group to each of my data columns eg I have employees years of service and I want to add a group such as 1-5 years 6-10 years etc Name Years of Service Group J Blogs 2.5 1 - 5 years S Smith 11 11-15 years The only way I can think of doing it is by using IF statments to say if the value is between 1 and 5 put '1-5 years' etc but this would need more than 7 nested IF's and I have been told that if you need more than 7 there is a better way of doing it! Could a vlookup work and if so, how do you get it to look at values within a range? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if then statement (i think) or vlookup | Excel Worksheet Functions | |||
| using vlookup within an if statement | Excel Worksheet Functions | |||
| Vlookup with if statement | Excel Discussion (Misc queries) | |||
| Vlookup with if statement | Excel Discussion (Misc queries) | |||
| VLOOKUP with IF statement | Excel Discussion (Misc queries) | |||
Threaded Mode
