Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • MantaLady
    3. Replies
      5
      Views
      696
      5

    4. AliGW

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

      • skeeeter
    3. Replies
      3
      Views
      577
      3

    4. pike

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

      • j6bennett1
    3. Replies
      1
      Views
      428
      1

    4. pike

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

      • jask
      • jask
    3. Replies
      1
      Views
      645
      1

    4. alansidman

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

      • sathishsusa
    3. Replies
      15
      Views
      1.9k
      15

    4. Joris Moerings

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

      • CCA BSM
    3. Replies
      3
      Views
      6.6k
      3

    4. S O

    2. Map text to numeric rankings 2

      • clariinc
    3. Replies
      2
      Views
      669
      2

    4. clariinc

    2. Add a trend arrow to dashboard 1

      • shanethompson
    3. Replies
      1
      Views
      1.4k
      1

    4. AAE

    2. SUMIF using Variable Columns 4

      • sajo
    3. Replies
      4
      Views
      1.1k
      4

    4. sajo

    2. Time calculation inconsistent 1

      • Gyster
    3. Replies
      1
      Views
      492
      1

    4. Gyster

    2. Power Forecast Formula Errors Out on Legitimate Value 3

      • JamesRyann
    3. Replies
      3
      Views
      713
      3

    4. JamesRyann

    2. CONCAT formula to use commas 1

      • Lulu29
    3. Replies
      1
      Views
      532
      1

    4. richadj4

    2. Tracking hours and pay outstanding in spreadsheet 1

      • daamyour
    3. Replies
      1
      Views
      605
      1

    4. richadj4

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

      • annasigler
    3. Replies
      2
      Views
      1.3k
      2

    4. richadj4

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

      • bellevue
    3. Replies
      4
      Views
      707
      4

    4. NBVC

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

      • excellquestion
    3. Replies
      1
      Views
      438
      1

    4. NBVC

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

      • R. Saran
    3. Replies
      1
      Views
      638
      1

    4. Krishnakumar

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

      • SBRIGHT
    3. Replies
      1
      Views
      467
      1

    4. NBVC

    2. Extract Value from a Text String 1

      • beewketu
    3. Replies
      1
      Views
      483
      1

    4. beewketu

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

      • Mathman1
    3. Replies
      4
      Views
      1.3k
      4

    4. Stanley D. Grom

Display Options