Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Nested IF Statement Alternative 8

      • aussiformula
    3. Replies
      8
      Views
      1.3k
      8

    4. aussiformula

    2. Monthly Allocation 3

      • kapil.raj1985
    3. Replies
      3
      Views
      745
      3

    4. crushdrinker06

    2. Countif or Array Formula 3

      • aussiformula
    3. Replies
      3
      Views
      1.1k
      3

    4. crushdrinker06

    2. Multiple Drop Downs dependent on the previous 1

      • rklafka
    3. Replies
      1
      Views
      552
      1

    4. crushdrinker06

    2. Trying to create formula to exclude any cells that contain the word "D/C" 7

      • Anmari
    3. Replies
      7
      Views
      1.1k
      7

    4. Anmari

    2. Vlookup issues, if no is data found 1

      • jest3r
    3. Replies
      1
      Views
      843
      1

    4. AliGW

    2. adding dynamic range to get rid of blanks 1

      • chubbychub
    3. Replies
      1
      Views
      838
      1

    4. pike

    2. Look for value based on multiple ranges 3

      • MagsinoAS
    3. Replies
      3
      Views
      742
      3

    4. pike

    2. Excel changing part of the formula w/o logical cause 6

      • Michael AQ
    3. Replies
      6
      Views
      964
      6

    4. Michael AQ

    2. If statement 2

      • aussiformula
    3. Replies
      2
      Views
      649
      2

    4. aussiformula

    2. Allocate points from 0-100 based on value 3

      • morsoe
    3. Replies
      3
      Views
      1k
      3

    4. crushdrinker06

    2. IF statement to find a value 2

      • SaraO
    3. Replies
      2
      Views
      704
      2

    4. SaraO

    2. Sum of Calculation in single Cell 4

      • GIRISHBISHT
    3. Replies
      4
      Views
      893
      4

    4. pike

    2. Excel Formula Sum of Minimum Values 10

      • GIRISHBISHT
    3. Replies
      10
      Views
      1.5k
      10

    4. pike

    2. Auto Fill Down Number List 11

      • luarbiasa
    3. Replies
      11
      Views
      1.7k
      11

    4. GIRISHBISHT

    2. Formula to display "Credit" 2

      • SaraO
    3. Replies
      2
      Views
      679
      2

    4. SaraO

    2. Give new List including duplicates ignoring zeros 3

      • juriemagic
    3. Replies
      3
      Views
      1k
      3

    4. FDibbins

    2. Formula Query dependent on outputs of others 4

      • HOC
      • HOC
    3. Replies
      4
      Views
      920
      4

    4. HOC

    2. Pick and display the right number using different match criterias. 2

      • AntoAnto
    3. Replies
      2
      Views
      607
      2

    4. AntoAnto

    2. Modified vlookup returning multiple values 2

      • COGICPENNY
    3. Replies
      2
      Views
      674
      2

    4. NBVC

Display Options