+ Reply to Thread
Results 1 to 5 of 5

Help, I need a logical test for multiple ranges, returing various text answers, Excel 2010

  1. #1
    Registered User
    Join Date
    02-14-2012
    Location
    High Desert, CA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Question Help, I need a logical test for multiple ranges, returing various text answers, Excel 2010

    I need a formula that checks the numerical value in cell d11. There are four ranges to be checked, each range would then assign an appropriate text. If the cell does not contain a number in those specified ranges, then it would display the text: Error

    put another way, I think the English synax would be like this:

    If d11 is less than (value), then "word1", if d11 is > than (value) but < (value), then "word2", if d11 is > than (value) but < (value), then "word3", if d11 is > (value), then "word4", else "Error"

    Thanks in advance!

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Help, I need a logical test for multiple ranges, returing various text answers, Excel

    Can you attach a workbook with some sample data and the expected result for that sample.

    Go Advanced -> Manage Attachments -> Upload

  3. #3
    Registered User
    Join Date
    02-14-2012
    Location
    High Desert, CA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Help, I need a logical test for multiple ranges, returing various text answers, Excel

    Trying to figure attachments out, not having any luck so far. I get to the point, whete the file is chosen from my PC, then I click the upload button, and the chosen file is no longer shown in the choose file queue. Seems like the only thing left to do from there, is to close that manage attachments window. Then, I am back to the editor, which is a blank page.

    OK, never mind, there it is!
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    660

    Re: Help, I need a logical test for multiple ranges, returing various text answers, Excel

    Hi,

    For your uploaded sample, if D11 is Text or Negative, result is "Error", formula in D12:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-14-2012
    Location
    High Desert, CA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Help, I need a logical test for multiple ranges, returing various text answers, Excel

    Thank you so much jtakw, that works for my purposes just fine. It is a real blessing that there are smart people willing to help others!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Logical Test on a Substring in a Text
    By MexicoGuy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-28-2016, 10:52 PM
  2. [SOLVED] Multiple logical test - excel problem help please
    By CYCHEAH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2015, 01:53 PM
  3. [SOLVED] Formula structure for IF/THEN with logical test value ranges
    By floridarandy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2014, 07:22 PM
  4. Replies: 2
    Last Post: 02-06-2013, 12:16 PM
  5. [SOLVED] CREATE A LOGICAL TEST CONTAINING TEXT
    By help needed in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2006, 10:05 AM
  6. [SOLVED] Logical Test if statements with text--Excel 2002
    By Don Guillett in forum Excel General
    Replies: 3
    Last Post: 11-02-2005, 07:35 PM
  7. Logical Test if statements with text--Excel 2002
    By Matt in forum Excel General
    Replies: 0
    Last Post: 11-02-2005, 06:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1