+ Reply to Thread
Results 1 to 4 of 4

Return specific values based on the range in another cell

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    8

    Return specific values based on the range in another cell

    Please forgive me if this is something answered in another thread. I am new to this forum and this is my first post.

    I am trying to put together a calculation sheet for court costs and I need a cell to return a value based on the amount entered in another cell. For example, if I input a value between 1 and 5 in cell A1, I would like "Cat" to appear in cell A2. However, if I input a value between 6 and 10 in cell A1, I would like "Dog" to appear in cell A2. Is this something that can be done without VB?

    For the real spreadsheet, I would need the following outputs in cell A2 based on the respective ranges in cell A1:

    Output to A2 = $405 if input to A1 is < $50,000.
    Output to A2 = $905 if input to A1 is ≥ $50,000 and < $250,000
    Output to A2 = $1,905 if input to A1 is ≥ $250,000

    Thank you!

  2. #2
    Registered User
    Join Date
    11-14-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Return specific values based on the range in another cell

    Follow up...

    I found out how to do this using the "INDEX" function. Thank you! I have a new question now, but I'll start a new thread for it.

    Thanks!

  3. #3
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Return specific values based on the range in another cell

    =405*(a1<50000)+905*(a1>=50000)*(a1<250000)+1905*(a1>=250000)
    Gary's Student

  4. #4
    Registered User
    Join Date
    11-14-2012
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Return specific values based on the range in another cell

    Thanks Jakobshavn!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1