Results 1 to 7 of 7

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User brnn's Avatar
    Join Date: Jun:2006
    Location:
    Posts: 754

    Excel

    :

    E5 B16:B19 B5 - , B5. "26", "3" . , . E5 B5 -, ... [250000-25999], , . , , ( IF-, ). ? IF OR , - IF, ?

  2. #2
    Registered User ined's Avatar
    Join Date: Nov:2006
    Location: Varna
    Posts: 1,078
    E5 =vlookup(B5,$A$16:$B$19,2)
    ($- A16:B19 5 6, 7 . B5, B6, B7...)
    Last edited by ined; 16th March 2011 at 19:56.
    ASRock B85 Pro4, Pentium G3240, DD3 8GB/1333MHz, 120GB SSD + 1TB + 640GB HDD
    Gigabyte GV-R657OC-1GI, CM B500, ASUS 24B1S1, LCD SAMSUNG SM931BW, 173

  3. #3
    Registered User brnn's Avatar
    Join Date: Jun:2006
    Location:
    Posts: 754
    Quote Originally Posted by ined View Post
    E5 =vlookup(B5,$A$16:$B$19,2)
    , , , .

  4. #4
    Registered User ined's Avatar
    Join Date: Nov:2006
    Location: Varna
    Posts: 1,078
    Quote Originally Posted by brnn View Post
    , , , .
    , 0 -. ' '25 '26 '27 ..., . =vlookup(text(B5,0),$A$16:$B$19,2)
    Last edited by ined; 16th March 2011 at 20:59.
    ASRock B85 Pro4, Pentium G3240, DD3 8GB/1333MHz, 120GB SSD + 1TB + 640GB HDD
    Gigabyte GV-R657OC-1GI, CM B500, ASUS 24B1S1, LCD SAMSUNG SM931BW, 173

  5. #5
    Registered User brnn's Avatar
    Join Date: Jun:2006
    Location:
    Posts: 754
    , , ? , averageif... Average , averageif? , ...

  6. #6
    Registered User ined's Avatar
    Join Date: Nov:2006
    Location: Varna
    Posts: 1,078
    Excel 2003, averageif.
    2003 verage - , averagea .
    ASRock B85 Pro4, Pentium G3240, DD3 8GB/1333MHz, 120GB SSD + 1TB + 640GB HDD
    Gigabyte GV-R657OC-1GI, CM B500, ASUS 24B1S1, LCD SAMSUNG SM931BW, 173

  7. #7
    Registered User
    Join Date: Sep:2010
    Location:
    Posts: 13

    EXCEL 2007

    ,
    :
    G2 - ,
    , 20-2 , 18
    J2 18. , G2 ,

    2. , ,
    3.
    4. C2 - 2 D2 , 1 1,50

    vllookup , , - .. .

    ,

    if and, . :
    -if(and(D2=),(E2=)),2,if(and(D2= ),(E2=)),1,if(and(D2=),(E2 =)),1,50,0)

    , ?



    http://dox.bg/files/dw?a=48fda249a3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |