Results 1 to 6 of 6

Check if cell contains a number in a given range of numbers

Threaded View

  1. 05-26-2022, 04:18 PM #1
    smockpuv
    smockpuv is offline
    Registered User
    Join Date
    04-02-2013
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    33

    Check if cell contains a number in a given range of numbers

    I'm trying to build out a formula to return a letter based on a tree of possible answers from different columns. I've attached an image of the table I'm trying to build the equation for. Basically if column A contains a 9 or a 10 and if column B contains 10, 9, or 8 and column C contains 10, 9, 8, ...1, then return an H, else, check back in column A and continue on. I'm not sure how to simplify the equation so I'm not doing a million IF(OR()) statements.
    Screenshot at May 26 14-12-38.png
    Last edited by smockpuv; 05-26-2022 at 04:20 PM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Removing a number or a range of numbers from a numeric cell
    By khank in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2015, 03:48 PM
  2. Check for Number in one column - then count specific numbers in a range.
    By CarlosM1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-29-2014, 05:10 AM
  3. Vba code to check a number in a cell against numbers in a column
    By Buddy8 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-07-2014, 03:33 PM
  4. [SOLVED] Output a specific number from range of numbers in one cell
    By Sigmaiota in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2014, 01:03 AM
  5. [SOLVED] check if number in once cell exists in a range of cells and if yes, format another cell
    By beaujolais44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2013, 07:23 AM
  6. Check range for number if found paste data into cell
    By Sal1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2011, 03:29 PM
  7. when typing to a cell check if this number exist in a range of cells (in sheet 2)
    By gtserkou in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-28-2008, 01:18 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