Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This should be simple - I want an If statement like so - If(B2>=1 and B2<=50,"1-50",A2). I am not sure of the proper syntax. Thanks for your help

    I figured it out.

    =if(and(B1>0,B<51),"1-50",A1)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Note you forgot the row number in your second condition:
    =if(and(B1>0,B1<51),"1-50",A1)

    You could have also used:
    =if(and(B1>=1,B1<=50),"1-50",A1)

    to match more exactly your original query.

    [Anything >0 and <1 as well as those things >50 and <51 will be listed as "1-50" in your formula, but would not in my modification]


    Steve

Posting Permissions

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