Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Convert Decimal To Text in Fraction format 1

      • JohnDrew
    3. Replies
      1
      Views
      891
      1

    4. rory

    2. Sum if with 2 conditions 1

      • eurano
    3. Replies
      1
      Views
      738
      1

    4. NBVC

    2. Excel formula err lookup 1

      • libin baby
    3. Replies
      1
      Views
      845
      1

    4. NBVC

    2. Sumproduct and mid function 1

      • eurano
    3. Replies
      1
      Views
      874
      1

    4. NBVC

    2. VLOOKUP does not return the correct values 1

    3. Replies
      1
      Views
      956
      1

    4. crushdrinker06

    2. SharePoint data not transferring to Table in Excel Completely 1

      • Vonsteiner
    3. Replies
      1
      Views
      737
      1

    4. Vonsteiner

    2. Index match with part of the text as condition 1

      • eurano
    3. Replies
      1
      Views
      904
      1

    4. crushdrinker06

    2. Dynamic Named range counting "" in data range 1

      • BScott05
    3. Replies
      1
      Views
      781
      1

    4. skywriter

    2. Put a formula in a text formatted cell. 1

      • reddale
    3. Replies
      1
      Views
      782
      1

    4. cytop

    2. Find all data using one criteria 1

      • hollyj
    3. Replies
      1
      Views
      780
      1

    4. skywriter

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

      • rnomis
    3. Replies
      1
      Views
      802
      1

    4. crushdrinker06

    2. Executing a formula based on an IF statement 1

      • corcelle
    3. Replies
      1
      Views
      731
      1

    4. skywriter

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

      • AussieNat
    3. Replies
      1
      Views
      744
      1

    4. crushdrinker06

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

      • AFerg85
    3. Replies
      1
      Views
      748
      1

    4. MrRedli

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

      • suresh45
    3. Replies
      1
      Views
      753
      1

    4. cytop

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

      • oddcarout
    3. Replies
      1
      Views
      641
      1

    4. skywriter

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

      • AussieNat
    3. Replies
      1
      Views
      994
      1

    4. ansonsia

    2. Prevent Duplicate in Drop Down List 1

      • kapil.raj1985
    3. Replies
      1
      Views
      1.7k
      1

    4. pike

    2. Multiplying a number betwee ranges in an IF statement 1

      • MichelleY16
    3. Replies
      1
      Views
      827
      1

    4. NBVC

    2. Cell Reference and sorting 1

      • dtp81390
    3. Replies
      1
      Views
      770
      1

    4. crushdrinker06

Label

Display Options