+ Reply to Thread
Results 1 to 2 of 2

Excel formula for range of numbers, help!

  1. #1
    Registered User
    Join Date
    05-15-2012
    Location
    Belgrade
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel formula for range of numbers, help!

    Hi All,
    i have a column with numbers between 0-85 and i need to create a column with specified text depenting on numbers in range, and if it's posible to put it in macro to work

    Example:

    from 0 to 9 text1
    from 10 to 14 text2
    from 15 to 24 text3
    from 25 to 34 text4
    from 35 to 39 text5
    from 40 to 44 text6
    from 45 to 54 text7
    from 55 to 64 text8
    from 65 to 74 text9
    from 75 to 84 text10
    from 85 to infinity text11


    Thank you!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Excel formula for range of numbers, help!

    You could use a formula

    =IF(A1="","",LOOKUP(A1,{0,10,15,25,35,40,45,55,65,75,85},{"Text1","Text2","Text3","Text4","Text5","Text6","Text7","Text8","Text9","Text10","Text11"}))
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1