Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • creativespace
    2. Replies
      2
      Views
      616
      2
    3. creativespace

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

      • abs_brum
    2. Replies
      2
      Views
      571
      2
    3. abs_brum

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

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

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

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

    1. Conditional Formatting with Date/Time 4

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

    1. vlookup to count based on criteria? 6

      • Gemma86
    2. Replies
      6
      Views
      1.2k
      6
    3. Gemma86

    1. AverageIf #DIV/0! error 10

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

    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
      713
      5
    3. pike

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

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

    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
      727
      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. Allocate a value over multiple years based on a specified date range 1

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

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

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

    1. Formula to return which quartile a given number falls in 3

      • CCA BSM
    2. Replies
      3
      Views
      6.8k
      3
    3. S O

    1. Map text to numeric rankings 2

      • clariinc
    2. Replies
      2
      Views
      698
      2
    3. clariinc

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

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

    1. Time calculation inconsistent 1

      • Gyster
    2. Replies
      1
      Views
      510
      1
    3. Gyster

    1. Power Forecast Formula Errors Out on Legitimate Value 3

      • JamesRyann
    2. Replies
      3
      Views
      753
      3
    3. JamesRyann

Display Options