Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Payroll timesheet with complex payrate structure needing formula variation 1

      • AussieNat
    2. Replies
      1
      Views
      807
      1
    3. ansonsia

    1. vlookup cell values only if date on adjacent column less than requested. INDEX/MATCH? 9

      • Elusive
    2. Replies
      9
      Views
      1.7k
      9
    3. sktneer

    1. Formula to update a cell date systematically 2

      • RNF
      • RNF
    2. Replies
      2
      Views
      638
      2
    3. sktneer

    1. Merge / Combine cell range into single cell with line break 2

      • Elusive
    2. Replies
      2
      Views
      1.1k
      2
    3. cytop

    1. Calculate average for specified numbers from a column 4

      • Mike91
    2. Replies
      4
      Views
      1k
      4
    3. S O

    1. Time Sheet Formula 5

      • scarlett_b
    2. Replies
      5
      Views
      988
      5
    3. scarlett_b

    1. Adding a range of cells based on addressing from a match 1

      • oddcarout
    2. Replies
      1
      Views
      510
      1
    3. skywriter

    1. merge cell invoice no auto increment frormulla is not working 1

      • suresh45
    2. Replies
      1
      Views
      615
      1
    3. cytop

    1. Count only first occurrence of criteria 3

      • Gaius
    2. Replies
      3
      Views
      801
      3
    3. Oeldere

    1. Employee Breakdown By Half Hour On Rotating 6 Week Schedule (Includes Training Day) 1

      • AFerg85
    2. Replies
      1
      Views
      601
      1
    3. MrRedli

    1. Incrementing multiple values in a cell 3

      • Facter
    2. Replies
      3
      Views
      791
      3
    3. crushdrinker06

    1. Combining <= and >= in same formula for time calculation 1

      • AussieNat
    2. Replies
      1
      Views
      585
      1
    3. crushdrinker06

    1. Executing a formula based on an IF statement 1

      • corcelle
    2. Replies
      1
      Views
      565
      1
    3. skywriter

    1. Align several columns into 1 columns 3

      • Kel13
    2. Replies
      3
      Views
      915
      3
    3. FlameRetired

    1. Join Excel tables 3

      • Kel13
    2. Replies
      3
      Views
      833
      3
    3. crushdrinker06

    1. Count the values by ignoring cells which contain NA 2

      • ravs_1006
    2. Replies
      2
      Views
      846
      2
    3. crushdrinker06

    1. add another IF to an IF, AND, OR statement 1

      • rnomis
    2. Replies
      1
      Views
      623
      1
    3. crushdrinker06

    1. compile error expected variable or procedure not module 2

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

    1. Combine if statement with 3 different return 6

      • JianHan
    2. Replies
      6
      Views
      1.1k
      6
    3. S O

    1. Counting numbers that appear in succession over different columns 2

      • MrCantaloupe
    2. Replies
      2
      Views
      669
      2
    3. FlameRetired

Display Options