+ Reply to Thread
Results 1 to 4 of 4

advanced formula

Hybrid View

lottopro1 advanced formula 06-15-2007, 08:53 PM
Paul In cell F1, put: ... 06-15-2007, 08:59 PM
lottopro1 thanks 06-15-2007, 09:32 PM
Paul You're welcome, glad I could... 06-15-2007, 09:35 PM
  1. 06-15-2007, 08:53 PM #1
    lottopro1 is offline
    Registered User
    Join Date
    06-15-2007
    Posts
    6

    advanced formula

    Looking for a formula that returns:

    1 in F1, G1, H1, I1, J1 if the number value is between less than 10
    2 if the value is between 10 and 19
    3 if the value is between 20 and 29 and
    4 if the value is between 30 and 39

    example A1, B1,C1,D1,E1 = 2 11 13 21 30 the formula should return :
    F1, G1, H1, I1, J1 = 1 2 2 3 4 respectively.
    Reply With QuoteRegister To Reply
  2. 06-15-2007, 08:59 PM #2
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    In cell F1, put:

    =LOOKUP(A1,{0,10,20,30},{1,2,3,4})

    Fill that to the right through J1.
    - Paul

    Click here to read the Forum Rules

    Reply With QuoteRegister To Reply
  3. 06-15-2007, 09:32 PM #3
    lottopro1 is offline
    Registered User
    Join Date
    06-15-2007
    Posts
    6

    thanks

    thx, it work perfectly
    Reply With QuoteRegister To Reply
  4. 06-15-2007, 09:35 PM #4
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    You're welcome, glad I could assist.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1