+ Reply to Thread
Results 1 to 6 of 6

IF B1 falls in one of four categories then return 1 or B1*27 or B1*54 or B1*107

  1. 04-19-2014, 09:52 AM #1
    roxie
    roxie is offline
    Registered User
    Join Date
    04-11-2014
    Location
    Greensboro, NC
    MS-Off Ver
    Excel 2007
    Posts
    10

    IF B1 falls in one of four categories then return 1 or B1*27 or B1*54 or B1*107

    Need a formula for C1 to look at B1 and if B1 is between 1 and 10 return 1, if B1 is between 11 and 30 return (B1*27), if B1 is between 31 and 50 return (B1*54), and if B1 is greater than 51 return (B1*107). Thanks!
    Attached Files Attached Files
    Last edited by roxie; 04-19-2014 at 10:06 AM.
    Reply With QuoteRegister To Reply
  2. 04-19-2014, 09:57 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,495

    Re: IF B1 falls in one of four categories then return 1 or B1*27 or B1*54 or B1*107

    Deleted. Incorrect!
    Last edited by AliGW; 04-19-2014 at 10:00 AM.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-19-2014, 10:01 AM #3
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: IF B1 falls in one of four categories then return 1 or B1*27 or B1*54 or B1*107

    Try this regular formula:
    Please Login or Register  to view this content.
    or...using a lookup table
    With E1:F3 containing this list:
    Please Login or Register  to view this content.
    This regular formula works:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  4. 04-19-2014, 10:02 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,495

    Re: IF B1 falls in one of four categories then return 1 or B1*27 or B1*54 or B1*107

    =if(b1<=10,b1,if(b1<=30,b1*27,if(b1<=50,b1*54,b1*107)))
    Reply With QuoteRegister To Reply
  5. 04-19-2014, 10:14 AM #5
    roxie
    roxie is offline
    Registered User
    Join Date
    04-11-2014
    Location
    Greensboro, NC
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: IF B1 falls in one of four categories then return 1 or B1*27 or B1*54 or B1*107

    Thanks! I was so focused on B1 being between numbers I didn't think about this.
    Reply With QuoteRegister To Reply
  6. 04-19-2014, 10:42 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,495

    Re: IF B1 falls in one of four categories then return 1 or B1*27 or B1*54 or B1*107

    You're welcome!
    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)

Similar Threads

  1. Return the Cell Value if it falls between either of two times of day
    By NYCTS in forum Excel General
    Replies: 4
    Last Post: 07-11-2012, 12:36 PM
  2. [SOLVED] Return value in X if date in Y falls between two dates - Help!
    By nephilim3uk in forum Excel General
    Replies: 4
    Last Post: 07-08-2012, 10:13 AM
  3. How to return a value that falls within a range
    By friend11_6 in forum Excel General
    Replies: 5
    Last Post: 03-18-2011, 01:06 AM
  4. return data that falls between a range
    By laerz103 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2009, 05:43 PM
  5. [SOLVED] Return a value that falls within a defined range
    By Suzieq in forum Excel General
    Replies: 2
    Last Post: 07-25-2006, 02:45 PM

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