Results 1 to 16 of 16

Logic test: Checking a number against multiple divisors

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2017
    Location
    Dayton, USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Logic test: Checking a number against multiple divisors

    Excel sages,

    I've got a column with a list of numbers in ascending order. I'd like to make a formula for the second column that draws out only those numbers that are not divisible by previous numbers in the column. I am not looking for prime numbers. I'm just trying to check divisibility (with no remainder) against multiple cells. Because my column A is in ascending order, I figured I could make the formula simpler by making the "divisor" any previous cells.

    I've created a mock-up to show what I'm going for:

    (Column A)
    Number list in ascending order
    5
    7
    12
    15
    20
    24
    53
    242

    Because 15, 20, and 24 are divisible by either 5 or 12, I'd like them to be dropped from Column B, and would like Column B to show:
    7
    12
    53
    242

    I tried the formula =IF(MOD(A9,(A2:A8))=0,"",A9) and pasted it in B9, but it returned #VALUE!

    I've used the MOD=0 formula before, but only using a single divisor. I imagine I'm getting the error because I'm using a range of cells as the divisor. NOTE: I'd rather not do each cell as an individual formula because although I've made my data smaller here, in the actual worksheet there are hundreds of numbers. I attached a simplified Excel worksheet here.

    Please help!

    Thanks
    J
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Checking multiple logic in a grid (or scatter chart)
    By Groomeister in forum Excel General
    Replies: 4
    Last Post: 01-12-2017, 11:43 AM
  2. Need Help in getting Divisors of a Number
    By sam_thesupreme in forum Excel - New Users/Basics
    Replies: 36
    Last Post: 12-28-2015, 11:31 PM
  3. [SOLVED] Simple multiple logic test help
    By rexy69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2014, 11:31 AM
  4. [SOLVED] Multiple logic test question
    By supernovartis in forum Excel General
    Replies: 4
    Last Post: 04-04-2014, 10:10 AM
  5. [SOLVED] logic test AND OR
    By censura in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2013, 05:48 AM
  6. Multiple logic test formulae
    By Jaime1234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2013, 12:27 PM
  7. Multiple conditional formatting - overcoming -ve divisors
    By Monkeyfuzzle in forum Excel General
    Replies: 1
    Last Post: 11-15-2011, 12:23 PM

Tags for this Thread

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