Hi all - I am using the IF statement below to categorise values as above 2k, 1-2k, 500-1k, 100 to 500 and less than 100.
However, it is miscategorising the results (saying 1964.39 is in the '500-1k' category for example (see atatched)) so I have obviously done something wrong.
Can someone correct my rookie error?
=IF(A1>=2000,"£2k+",IF(A1>2000,"£1-2k",IF(A1>1000,"£500-£1k",IF(A1>500,"£100-500",IF(A1<100,"Under£100")))))
Ta
Glayva
Last edited by Glayva; 09-12-2012 at 08:50 AM. Reason: solved
You can adapt this LOOKUP function.
Formula:
Please Login or Register to view this content.
Last edited by Kevin UK; 09-12-2012 at 08:05 AM. Reason: Miss read it, yet again!
Try this..
=IF(A1>=2000,"£2k+",IF(A1>1000,"£1-2k",IF(A1>500,"£500-£1k",IF(A1>100,"£100-500",IF(A1<100,"Under£100")))))
@KevinUK Ta but wouldn't this only work if the value is A1 was either 0,100,500,1000 or 200, not figures between / above these?
Thansk - this fixed it!
Sould be OK.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by 
Bookmarks