Results 1 to 3 of 3

Different MOD formula based on contents in another cell

Threaded View

  1. 05-17-2018, 01:59 AM #1
    Beitz75
    Beitz75 is offline
    Registered User
    Join Date
    11-04-2015
    Location
    Adelaide, South Australia
    MS-Off Ver
    Pro plus 2016
    Posts
    19

    Different MOD formula based on contents in another cell

    Hi All,
    Wondering if someone could help?
    I have a sheet that I use a MOD formula to get the remainder of a number.
    What I am trying to do is depending on the number in a cell depends on which MOD formula to use. So have more than one MOD condition in the formula.
    Is this even possible?

    What I have tried which partially works.

    =IF((AND(E2=7770,E2=7771)),MOD(F2,185),(MOD(F2,45)))

    Attached spreadsheet with my workings out.

    Thanks in advance
    Michael
    Attached Files Attached Files
    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] Changing range of max() formula based on a cell contents
    By Mr_Phil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2018, 07:14 PM
  2. Formula to show a cells contents based on another cell being selected from a formula
    By tigerpie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2016, 08:43 AM
  3. [SOLVED] Find Cell that matches based on other cell contents and display adjacent cell contents
    By Bobbbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2015, 03:03 PM
  4. [SOLVED] Formula to capture contents in one of 2 cells based on Yes or No in another cell
    By Squint in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2014, 01:27 PM
  5. Moving Cell contents with a formula, based on the column value?
    By bvandervyver44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2013, 02:51 AM
  6. Formula based on Contents of Particular Cell
    By scoopster in forum Excel General
    Replies: 10
    Last Post: 06-01-2010, 01:30 PM
  7. Using a formula (IF?) to place pos & neg. #s in cell, based on contents of diff. cell
    By Ymir20000000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2005, 08:21 AM

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