Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Formula and Macro update challenge 4

      • fatboy1973
    2. Replies
      4
      Views
      763
      4
    3. fatboy1973

    1. Formula I got for 1 cell drop down I can't tweaked for another cell drop down 1

      • PaulaD
    2. Replies
      1
      Views
      371
      1
    3. Carim

    1. combined index / address formula / select specific data 3

      • fatboy1973
    2. Replies
      3
      Views
      776
      3
    3. Carim

    1. Sum within PRODUCT Function 3

      • CH_GR
    2. Replies
      3
      Views
      659
      3
    3. Carim

    1. Forumula to find amounts in cell range in sheet 1 and total those amounts in sheet 2 5

      • nemmar
    2. Replies
      5
      Views
      1.1k
      5
    3. Carim

    1. Formula to show rental payments due on monthly, quarterly and annual basis 2

      • abs_brum
    2. Replies
      2
      Views
      572
      2
    3. abs_brum

    1. Sum extra hours worked before today and subtract leave hours based on text string 2

      • creativespace
    2. Replies
      2
      Views
      619
      2
    3. creativespace

    1. sum up the x in range to give proper percentage calculation 1

      • megatronixs
    2. Replies
      1
      Views
      609
      1
    3. NBVC

    1. Conditional Formatting with Date/Time 4

      • jnepsa
    2. Replies
      4
      Views
      769
      4
    3. jnepsa

    1. Finding Working Day from the Calendar Date using a formula 1

      • kumuda2505
    2. Replies
      1
      Views
      467
      1
    3. pike

    1. AverageIf #DIV/0! error 10

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

    1. Copy formula from Row above if Cell Value changes. 5

      • JohnDrew
    2. Replies
      5
      Views
      999
      5
    3. JohnDrew

    1. Minimum Date if cell contains part of another cell value 10

      • dRaz
      • dRaz
    2. Replies
      10
      Views
      1.5k
      10
    3. AliGW

    1. Removing Characters out of a long string of characters via formula 5

      • DaveSharpe79
    2. Replies
      5
      Views
      715
      5
    3. pike

    1. Convert Time into Hours in Excel 1

      • DaveSharpe79
    2. Replies
      1
      Views
      455
      1
    3. Flyboy65

    1. Return "YES" if cell H2 >12 and cell P2=Open - If no match return "NO" 5

      • MantaLady
    2. Replies
      5
      Views
      731
      5
    3. AliGW

    1. Formula that that leaves cell blank if 2 cells meet logical parameters 3

      • skeeeter
    2. Replies
      3
      Views
      591
      3
    3. pike

    1. Formula to count times a specific number will divide into another + rounding rules 1

      • j6bennett1
    2. Replies
      1
      Views
      443
      1
    3. pike

    1. Allocate a value over multiple years based on a specified date range 1

      • jask
      • jask
    2. Replies
      1
      Views
      676
      1
    3. alansidman

    1. select by data validation list to highlight the cells 15

      • sathishsusa
    2. Replies
      15
      Views
      2k
      15
    3. Joris Moerings

Display Options