Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Custom Week Number - Last Saturday in December is Week 1 23

      • m4Owen
    2. Replies
      23
      Views
      2.9k
      23
    3. Carim

    1. compile error expected variable or procedure not module 2

      • abdiwahab
    2. Replies
      2
      Views
      2.9k
      2
    3. royUK

    1. Converting Quarterly Data to Monthly Data 1

      • Rafaelbrians
    2. Replies
      1
      Views
      2.7k
      1
    3. Carim

    1. Generate cells with values from other cells 19

      • DataWarrior
    2. Replies
      19
      Views
      2.6k
      19
    3. DataWarrior

    1. calculate the number of years and months as of today and round to the nearest year 2

      • milgrl3
    2. Replies
      2
      Views
      2.6k
      2
    3. AliGW

    1. Flag if data is in top 80% of range 8

      • goin4boge
    2. Replies
      8
      Views
      2.6k
      8
    3. S O

    1. Exact same formula different results. 28

      • her.rockstar
    2. Replies
      28
      Views
      2.6k
      28
    3. NBVC

    1. "tilde" in vlookup formula 13

      • Anri
      • Anri
    2. Replies
      13
      Views
      2.5k
      13
    3. Carim

    1. Find Max number value from text-number cell? 20

      • B.W.B.
    2. Replies
      20
      Views
      2.5k
      20
    3. XOR LX

    1. AverageIf #DIV/0! error 10

      • Murph0625
    2. Replies
      10
      Views
      2.5k
      10
    3. NBVC

    1. Formula: Test for overlapping number ranges 3

      • jdawson422
    2. Replies
      3
      Views
      2.4k
      3
    3. p45cal

    1. How to use indirect formula to show value AND formatting? 26

      • carissa
    2. Replies
      26
      Views
      2.3k
      26
    3. Carim

    1. Find max value from vlookup against multiple sheets 12

      • CompleXcel
    2. Replies
      12
      Views
      2.3k
      12
    3. CompleXcel

    1. Excel formula to show text only IF another cell is greater than 0 5

      • Aikosassie2
    2. Replies
      5
      Views
      2.3k
      5
    3. Aikosassie2

    1. concatenateif formula not working ? 5

      • jacjas
    2. Replies
      5
      Views
      2.3k
      5
    3. KjBox

    1. Return Specific Value from adjacent cell if values match 5

      • JadeRae
    2. Replies
      5
      Views
      2.2k
      5
    3. skywriter

    1. Ignore blank cells in array formula 2

      • artsjeroen
    2. Replies
      2
      Views
      2.2k
      2
    3. artsjeroen

    1. IFERROR, ROUND and SUM together 2

      • DezB
      • DezB
    2. Replies
      2
      Views
      2.2k
      2
    3. DezB

    1. Find underline and bold text with cells. 14

      • cya
      • cya
    2. Replies
      14
      Views
      2.2k
      14
    3. Carim

    1. Convert pounds and ounces to decimal and other number questions 11

      • noyb1982
    2. Replies
      11
      Views
      2.1k
      11
    3. JonathanVH

Display Options