Excel Formulas

Questions related specifically to the use of Excel formulas.

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

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

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

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

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

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

    1. Map text to numeric rankings 2

      • clariinc
    2. Replies
      2
      Views
      666
      2
    3. clariinc

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

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

    1. Time calculation inconsistent 1

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

    1. Power Forecast Formula Errors Out on Legitimate Value 3

      • JamesRyann
    2. Replies
      3
      Views
      712
      3
    3. JamesRyann

    1. Find solution to #VALUE! error message in SUMPRODUCT 4

      • bellevue
    2. Replies
      4
      Views
      706
      4
    3. NBVC

    1. Average & standard deviation of hh:mm:ss 1

      • R. Saran
    2. Replies
      1
      Views
      637
      1
    3. Krishnakumar

    1. SUMIF using Variable Columns 4

      • sajo
    2. Replies
      4
      Views
      1.1k
      4
    3. sajo

    1. Formula to look at dates and bring back value 1

      • excellquestion
    2. Replies
      1
      Views
      438
      1
    3. NBVC

    1. Return text from colomn if meets criteria in another colomn 1

      • SBRIGHT
    2. Replies
      1
      Views
      466
      1
    3. NBVC

    1. Extract Value from a Text String 1

      • beewketu
    2. Replies
      1
      Views
      482
      1
    3. beewketu

    1. Add a trend arrow to dashboard 1

      • shanethompson
    2. Replies
      1
      Views
      1.4k
      1
    3. AAE

    1. CONCAT formula to use commas 1

      • Lulu29
    2. Replies
      1
      Views
      531
      1
    3. richadj4

    1. How to count consecutive numbers based on the first number of the column 4

      • Mathman1
    2. Replies
      4
      Views
      1.3k
      4
    3. Stanley D. Grom

    1. Run time error 13 Type mismatch in VBA 1

      • analystbank
    2. Replies
      1
      Views
      600
      1
    3. analystbank

    1. Formula to show which Staff have had no sick leave for previous 3 months 6

      • skeeeter
    2. Replies
      6
      Views
      877
      6
    3. AliGW

    1. Count number of zeros that are within a range of consecutive zeros 2

      • annasigler
    2. Replies
      2
      Views
      1.3k
      2
    3. richadj4

    1. Complex IF (AND (OR formula 8

      • missjoy
    2. Replies
      8
      Views
      1.4k
      8
    3. KjBox

Display Options