Thread: Excel formula

Results 1 to 4 of 4
  1. #1 Excel formula 
    Extreme Donator

    Lost Valentino's Avatar
    Join Date
    May 2009
    Posts
    3,793
    Thanks given
    12
    Thanks received
    344
    Rep Power
    1952
    I need to make an assigment for school by using Excel. I'm atm using a formula but i was thinking if this could be easier to write.

    Formula
    Code:
    =ALS(Verlofregistratie!D4="Verkoop";Verlofregistratie!I4;0)+ALS(Verlofregistratie!D7="Verkoop";Verlofregistratie!I7;0)+ALS(Verlofregistratie!D8="Verkoop";Verlofregistratie!I8;0)+ALS(Verlofregistratie!D9="Verkoop";Verlofregistratie!I9;0)+ALS(Verlofregistratie!D14="Verkoop";Verlofregistratie!I14;0)+ALS(Verlofregistratie!D16="Verkoop";Verlofregistratie!I16;0)+ALS(Verlofregistratie!D17="Verkoop";Verlofregistratie!I17;0)
    EDIT:
    ALS = IF
    Reply With Quote  
     

  2. #2  
    Extreme Donator

    Lost Valentino's Avatar
    Join Date
    May 2009
    Posts
    3,793
    Thanks given
    12
    Thanks received
    344
    Rep Power
    1952
    Bump
    Reply With Quote  
     

  3. #3  
    Extreme Donator

    Lost Valentino's Avatar
    Join Date
    May 2009
    Posts
    3,793
    Thanks given
    12
    Thanks received
    344
    Rep Power
    1952
    bump
    Reply With Quote  
     

  4. #4  
    Renown Programmer

    Join Date
    Dec 2010
    Posts
    2,876
    Thanks given
    508
    Thanks received
    1,898
    Rep Power
    5000
    use a macro?
    never talk to me or my wife's son ever again
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Formula for range max hit.
    By Stanyer in forum Tutorials
    Replies: 70
    Last Post: 05-31-2008, 05:41 PM
  2. Improved max hit formula (easy tut)
    By ringer23 in forum Tutorials
    Replies: 22
    Last Post: 05-24-2008, 07:48 PM
  3. 95% accurate current rs max cmb lvl formula
    By W W E in forum Tutorials
    Replies: 13
    Last Post: 03-02-2008, 12:15 AM
  4. A Good Range Formula
    By hoodlom in forum Tutorials
    Replies: 15
    Last Post: 02-16-2008, 04:24 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •