Results 1 to 14 of 14

Thread: Excel- if- ..

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851

    Excel- if- ..

    , , :



    , 3 / .

    2 , , , :
    , , (2 - , 1 - )...
    3 - , , ...

    .xsl-, ...
    , , 2 ,

    , , , ...
    - , ( - 1001 "", , Excel- )
    Attached Files

  2. #2
    Registered User netshacker's Avatar
    Join Date: May:2005
    Location:
    Posts: 126

  3. #3
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    "" 2 , 1 ,
    ""-, , (USD/EUR/GBR), / ("1"-, "2"-).

    - :
    MATCH,
    VLOOKUP, HLOOKUP,
    CHOOSE,
    ,

  4. #4
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    , , , , . , , . , , . - , 2( ) , (). , . . . . , .
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  5. #5
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    , , ,
    - 2 - (USD/EUR/GBR).

    , ... 1001 ,

  6. #6
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    , , . , . Match , :

    =MATCH(kletka s data ot tablica 2,A8:A12,0) - 1 . . . . - 8:12 . , ,
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  7. #7
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    =MATCH(kletka s data ot tablica 2,A8:A12,0) 1
    , ...

    edit


    ...
    Last edited by Pa3KaTaH; 7th February 2006 at 16:12.

  8. #8
    Registered User
    Join Date: Feb:2006
    Location: Sofia
    Posts: 1
    =VLOOKUP(B25;OFFSET($A$7;1;0;COUNTA($A$8 :$A$12);COUNTA($B$7:$G$7));IF($E25=" ";MATCH($C25;$B$7:$D$7;0);MATCH($C25;$ E$7:$G$7;0)+COUNTA($B$7:$D$7))+1;FALSE)

  9. #9
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    , ,
    singularity
    Attached Files

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 |