Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Formula summing up even if the reference cell is empty 3

      • DezB
      • DezB
    3. Replies
      3
      Views
      123
      3

    4. rory

    2. Saving data based on date without having to use a macro 6

      • DezB
      • DezB
    3. Replies
      6
      Views
      116
      6

    4. Carim

    2. SUMIFS or SUMPRODUCT both returning #VALUE error 2

      • DezB
      • DezB
    3. Replies
      2
      Views
      129
      2

    4. Carim

    2. Conditional Formatting to highlight column based on date in row 5

      • DezB
      • DezB
    3. Replies
      5
      Views
      228
      5

    4. Carim

    2. How to create Conditional Formatting with a range of dates? 4

      • GradB
    3. Replies
      4
      Views
      161
      4

    4. Carim

    2. Count values on a row that are within, equal to or greater than a value in row within the same column 4

      • Shezmo1
    3. Replies
      4
      Views
      497
      4

    4. Carim

    2. Pivot Table with a filter that displays a SUM of Total with a specific number or numbers 11

      • PETRODATAjames
    3. Replies
      11
      Views
      730
      11

    4. Carim

    2. INDEX/MATCH Formula - beyond me 11

      • DezB
      • DezB
    3. Replies
      11
      Views
      188
      11

    4. Carim

    2. Find matching string and get string of data in offset cell from raw dataset 15

      • robystar
    3. Replies
      15
      Views
      725
      15

    4. Carim

    2. How to identify leaders? 9

      • GradB
    3. Replies
      9
      Views
      410
      9

    4. Carim

    2. Calculate the date between to cells 4

      • PETRODATAjames
    3. Replies
      4
      Views
      574
      4

    4. Carim

    2. Formula with cap 10

      • DANGPS
    3. Replies
      10
      Views
      325
      10

    4. DANGPS

    2. Date in Excel if it is a Working Day 3

      • skamat
    3. Replies
      3
      Views
      181
      3

    4. Carim

    2. Hourly Payroll Template 9

      • PETRODATAjames
    3. Replies
      9
      Views
      521
      9

    4. Carim

    2. Payroll worksheet with VLOOKUP issues 18

      • PETRODATAjames
    3. Replies
      18
      Views
      460
      18

    4. Carim

    2. Predefined text in a cell 4

      • Allround_IT_er
    3. Replies
      4
      Views
      224
      4

    4. Carim

    2. Adding one more variable to an IF statement Formula 6

      • SkateRockandRoll
    3. Replies
      6
      Views
      321
      6

    4. Carim

    2. Need help to correct the error in the formula 2

      • RAJESH SHAH
    3. Replies
      2
      Views
      106
      2

    4. RAJESH SHAH

    2. NPER with daily compounding interest? 6

      • jronaldlee
    3. Replies
      6
      Views
      237
      6

    4. Carim

    2. Calculating a level 2

      • Kyp
      • Kyp
    3. Replies
      2
      Views
      238
      2

    4. Carim

Label

Display Options