Excel 2007 Problem with an IF statement . Help
Hi Folks, I'd appreciate any help and many thanks in advance for taking the time. I've excel 2007 and I'm trying to built a table . column A will contain a number of random figures from -1 to 100. The table starting in column C through to column AB will run parallel and each column being a category 1, 2-5, 6-10, 11-20, 21-30 and so on below is the formula that when placed in C2 will show the result of 1 if 1 is in that cell =IF(ISNUMBER(SEARCH("1",A2)),A2,"") the problem I have is how do I formulate code where i need a range from 2-5 ? so if 3.3 turns up in cell A2 3.3 will show in the category 1-5 I can only do single digits and I need to be able to cover a range of numbers and those in between up to 2 decimal place
