Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Nested IF Statement Alternative 8

      • aussiformula
    2. Replies
      8
      Views
      1.3k
      8
    3. aussiformula

    1. Monthly Allocation 3

      • kapil.raj1985
    2. Replies
      3
      Views
      745
      3
    3. crushdrinker06

    1. Countif or Array Formula 3

      • aussiformula
    2. Replies
      3
      Views
      1.1k
      3
    3. crushdrinker06

    1. Multiple Drop Downs dependent on the previous 1

      • rklafka
    2. Replies
      1
      Views
      552
      1
    3. crushdrinker06

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

      • Anmari
    2. Replies
      7
      Views
      1.1k
      7
    3. Anmari

    1. Vlookup issues, if no is data found 1

      • jest3r
    2. Replies
      1
      Views
      843
      1
    3. AliGW

    1. adding dynamic range to get rid of blanks 1

      • chubbychub
    2. Replies
      1
      Views
      838
      1
    3. pike

    1. Look for value based on multiple ranges 3

      • MagsinoAS
    2. Replies
      3
      Views
      742
      3
    3. pike

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

      • Michael AQ
    2. Replies
      6
      Views
      964
      6
    3. Michael AQ

    1. If statement 2

      • aussiformula
    2. Replies
      2
      Views
      649
      2
    3. aussiformula

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

      • morsoe
    2. Replies
      3
      Views
      1k
      3
    3. crushdrinker06

    1. IF statement to find a value 2

      • SaraO
    2. Replies
      2
      Views
      704
      2
    3. SaraO

    1. Sum of Calculation in single Cell 4

      • GIRISHBISHT
    2. Replies
      4
      Views
      893
      4
    3. pike

    1. Excel Formula Sum of Minimum Values 10

      • GIRISHBISHT
    2. Replies
      10
      Views
      1.5k
      10
    3. pike

    1. Auto Fill Down Number List 11

      • luarbiasa
    2. Replies
      11
      Views
      1.7k
      11
    3. GIRISHBISHT

    1. Formula to display "Credit" 2

      • SaraO
    2. Replies
      2
      Views
      679
      2
    3. SaraO

    1. Give new List including duplicates ignoring zeros 3

      • juriemagic
    2. Replies
      3
      Views
      1k
      3
    3. FDibbins

    1. Formula Query dependent on outputs of others 4

      • HOC
      • HOC
    2. Replies
      4
      Views
      920
      4
    3. HOC

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

      • AntoAnto
    2. Replies
      2
      Views
      607
      2
    3. AntoAnto

    1. Modified vlookup returning multiple values 2

      • COGICPENNY
    2. Replies
      2
      Views
      674
      2
    3. NBVC

Display Options