Search:

Tag: mod

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Using MOD and IF to find cell value vs reference and show if divisible but I have an issue

    Started by ceepeebee‎, 04-15-2023 12:59 PM
    mod 18 Attachment(s)
    • 1,159
    Last Post: 06-20-2023 10:40 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  2. Insert Row Based on Cell Value and Mod Function Help

    Started by rjj920‎, 02-27-2023 08:49 PM
    count row, do while, loop, mod
    • 318
    Last Post: 02-28-2023 01:55 PM
    by Artik  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  3. [SOLVED] MOD function question

    Started by BMaxx‎, 11-16-2022 12:24 PM
    array, mod 4 Attachment(s)
    • 630
    Last Post: 11-16-2022 02:29 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel General

  4. [SOLVED] IF/VLOOKUP & MOD Subtotal backwards math calculation

    Started by pottie8‎, 07-17-2022 12:11 PM
    calculate cell, column, mod, nested formulas 6 Attachment(s)
    • 620
    Last Post: 07-20-2022 06:11 AM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  5. Finding multiple criteria in nth rows

    Started by Silent Whale‎, 02-05-2022 02:33 PM
    isnumber, mod, multiple criteria, sumproduct, timesheets 2 Attachment(s)
    • 554
    Last Post: 02-07-2022 04:31 PM
    by Silent Whale  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] How to use MOD as a criteria in MAXIFS formula or any other solution to my problem

    Started by Govind0186‎, 12-13-2020 02:24 AM
    index and match, lookup & references, maxifs, mod, referencing 3 Attachment(s)
    • 953
    Last Post: 12-28-2020 12:47 PM
    by Govind0186  Go to last post

    Forum:
    Excel Formulas & Functions

  7. Modify Cell based on the value of the other cell by using VBA

    Started by jamesrule1‎, 12-07-2020 09:18 AM
    excel, mod, modify, vba
    • 347
    Last Post: 12-07-2020 10:34 AM
    by vba_php  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  8. Formula for Shift Roster being thrown off by leap years?

    Started by Ulysses98‎, 07-06-2020 01:41 AM
    excel, formula, mid, mod, roster 2 Attachment(s)
    • 469
    Last Post: 07-06-2020 03:32 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] Count only Odd numbers between 1-15 from table of data

    Started by Nascent23‎, 02-25-2020 06:05 AM
    counifs, mod, sumproduct
    • 844
    Last Post: 02-25-2020 07:31 AM
    by Nascent23  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] SUM on MOD

    Started by 77highland‎, 02-11-2020 09:18 AM
    mod, sum 1 Attachment(s)
    • 521
    Last Post: 02-11-2020 11:20 AM
    by 77highland  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Using Excel to create a rota with 5 different shift times, rotating and according to teams

    Started by kayjay46‎, 01-15-2020 01:35 PM
    automatic rotation, index, mod, rotas, shifts 3 Attachment(s)
    • 1,666
    Last Post: 01-17-2020 12:44 PM
    by BlindAlley  Go to last post

    Forum:
    Excel Formulas & Functions

  12. Dynamic MOD & COLUMNS formula

    Started by dcwood57‎, 08-19-2019 07:12 PM
    columns, concatenate formula, mod, vlookup 2 Attachment(s)
    • 867
    Last Post: 08-23-2019 12:32 PM
    by dcwood57  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] SUMPRODUCT using MOD to sum odd columns

    Started by UltimateNeo‎, 05-24-2019 09:53 PM
    mod, odd columns, sumproduct
    • 1,489
    Last Post: 05-28-2019 08:21 PM
    by UltimateNeo  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] Summing up every 125 rows

    Started by Rakel‎, 10-30-2018 07:21 AM
    index, mod, offset, sum, sumprodcut 3 Attachment(s)
    • 654
    Last Post: 11-08-2018 03:32 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  15. [SOLVED] Caesar Cipher MOD VLOOKUP Function Help

    Started by dchen298‎, 04-26-2018 12:15 PM
    caesar cipher, mod, vlookup 1 Attachment(s)
    • 1,291
    Last Post: 04-27-2018 08:17 AM
    by Jacc  Go to last post

    Forum:
    Excel Formulas & Functions

  16. [SOLVED] [vba] mod function not working for variables bigger than 'long'

    Started by AB91‎, 09-24-2017 03:23 PM
    mod, prime factor, prime factors, vba
    • 547
    Last Post: 09-24-2017 05:02 PM
    by xladept  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  17. [SOLVED] Sum every third cell formula

    Started by Rellsunn‎, 08-21-2017 07:35 PM
    mod, sumproduct 1 Attachment(s)
    • 601
    Last Post: 08-21-2017 09:37 PM
    by Rellsunn  Go to last post

    Forum:
    Excel Formulas & Functions

  18. [SOLVED] MOD function incorrect outcome

    Started by Vitalite‎, 07-30-2017 11:22 AM
    mod 2 Attachment(s)
    • 1,028
    Last Post: 07-30-2017 05:23 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  19. [SOLVED] Sum If Divisible by 100

    Started by sskgintl‎, 06-07-2017 12:02 AM
    divisible by, mod, sumprodcut
    • 1,476
    Last Post: 06-07-2017 12:03 AM
    by humdingaling  Go to last post

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] TRUNC and MOD results return FALSE even when true

    Started by sskgintl‎, 05-24-2017 12:21 AM
    false, mod, trunc 1 Attachment(s)
    • 682
    Last Post: 05-24-2017 10:44 AM
    by sandy666  Go to last post

    Forum:
    Excel Formulas & Functions

  21. Divisible IF statements

    Started by Wiggy74‎, 12-21-2016 09:28 AM
    functions, functions and formula, if statements, mod 1 Attachment(s)
    • 4,931
    Last Post: 12-21-2016 09:50 AM
    by etaf  Go to last post

    Forum:
    Excel Formulas & Functions

  22. [SOLVED] formula value behaves as text on numeric result

    Started by analystbank‎, 12-21-2016 03:32 AM
    mod, numeric text, trunc
    • 624
    Last Post: 12-21-2016 11:06 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  23. Excel Offset: Need Formula that Adjusts for Differences in Row Increments

    Started by rjj920‎, 06-25-2016 04:28 PM
    excel, increment, index, mod, offset
    • 893
    Last Post: 06-12-2017 08:45 PM
    by protonLeah  Go to last post

    Forum:
    Excel Formulas & Functions

  24. [SOLVED] Number intervals - positive to negative

    Started by froggeja‎, 04-27-2015 08:44 AM
    intervals, mod 2 Attachment(s)
    • 853
    Last Post: 04-27-2015 12:53 PM
    by samba_ravi  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Formula to Generate AAAAA to ZZZZZ

    Started by EmeraldCheetah‎, 03-23-2015 10:51 AM
    alphabet, char, mod
    • 5,008
    Last Post: 03-26-2015 06:26 AM
    by shg  Go to last post

    Forum:
    Excel Formulas & Functions

  26. decoding formula assistance

    Started by eehimes‎, 07-31-2014 01:28 PM
    luhn, mid, mod 1 Attachment(s)
    • 852
    Last Post: 07-31-2014 01:44 PM
    by eehimes  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [SOLVED] Sum every other row with multiple conditions including date less than

    Started by kingsHorses‎, 02-18-2014 03:50 PM
    date, mod, multiplecriteria, sumif, sumproduct 2 Attachment(s)
    • 819
    Last Post: 02-19-2014 08:44 PM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  28. MOD() Function Returns #NUM! Error Value

    Started by filky‎, 01-15-2014 06:59 PM
    #num!, mod, mod function
    • 976
    Last Post: 01-16-2014 04:40 AM
    by Izandol  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Move a cell if it is a multiple of 50.

    Started by brandoll23‎, 01-28-2013 04:05 PM
    if/then statement, mod, mod vba, modular, move cells
    • 703
    Last Post: 01-28-2013 04:14 PM
    by mrice  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  30. [SOLVED] Can a function be modified to accept a divisor?

    Started by Vba Novice‎, 01-12-2013 02:11 PM
    adding digit positions, mod, mod in vba
    • 578
    Last Post: 01-12-2013 04:14 PM
    by Norie  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  31. Loop - Determining if value is oriignal value+4 or multiple of it

    Started by ninaking‎, 12-07-2012 09:49 AM
    loops, mod, multiple, variables
    • 566
    Last Post: 12-07-2012 11:28 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  32. Vlookup a value in a different row coumn

    Started by RyanGauci‎, 11-06-2012 06:39 PM
    match, mod, offset function, vlook up 3 Attachment(s)
    • 1,217
    Last Post: 11-07-2012 05:32 PM
    by BB1972  Go to last post

    Forum:
    Excel Formulas & Functions

  33. Excel formula for a Roster of Managers On Duty (MOD)

    Started by Letmelearn‎, 09-11-2012 02:23 PM
    duty, formula, mod, roster 1 Attachment(s)
    • 1,681
    Last Post: 09-11-2012 02:29 PM
    by Søren Larsen  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Wrestingling with the IF function, MOD and multiple conditions

    Started by Meddy‎, 04-20-2012 06:18 AM
    grrr, if function, mod, more than
    • 937
    Last Post: 04-20-2012 06:44 AM
    by Emil Z  Go to last post

    Forum:
    Excel General

  35. Complex SUMIF

    Started by alexmitchell‎, 03-25-2012 11:35 AM
    mod, sumif, sumif formula, sumif two conditions
    • 1,073
    Last Post: 03-25-2012 12:21 PM
    by daddylonglegs  Go to last post

    Forum:
    Excel General

Results 1 to 35 of 40
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1