Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: If Statment VERY Simple

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    139
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Need the following... Comun A has the following numbers 1 through 100. Need to have column be return the following numbers.
    IF colum A the number is between 0 through 10 then return 1, if the number is between 11 - 25, then return 2, etc.....

    avo

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try:

    =IF(A1<11,1,IF(A1<26,2,"etc…"))

    Incidentally, how does this sequence make sense?

    _________________
    Cheers, NateO

    [ This Message was edited by: NateO on 2002-05-03 14:53 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =if(and(a1>0,a1<25),1,if(and(a1>25,a1<50),2,if...
    It's never too late to learn something new.

    Ricky

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ricky, that doesn't work for case 2, but conceptually sound. I'm guessing your sequence grows by 5 every increment 10, 15, 20, 25 (I feel like I'm taking the SAT here). Try this:

    =IF(A1<11,1,IF(A1<26,2,IF(A1<56,3,IF(A1<76,4,5))))

    _________________
    Cheers, NateO

    [ This Message was edited by: NateO on 2002-05-03 15:04 ]

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =VLOOKUP(A1,{0,1;11,2;26,3;...},2)

    [ This Message was edited by: Mark W. on 2002-05-03 14:59 ]

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Posts
    139
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you all for your great help..... You guys are really amazing....

  7. #7
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Neat trick Mark. Kudos.

  8. #8
    Board Regular
    Join Date
    Apr 2002
    Posts
    139
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thank you all for the help.... each of them works in a different way, but they all work.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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