Results 1 to 5 of 5

Thread: EXCEL 2003

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User lisi4ko's Avatar
    Join Date: Nov:2008
    Location: Varna
    Posts: 91

    EXCEL 2003

    ... OR AND ?
    :

    =IF(AND(OR(B5=J1;B5=K1);B8=L1);L3;IF(AND (OR(B5=J1;B5=K1);B8=M1);M3;IF(AND(OR(B5= J1;B5=K1);B8=N1);N3;IF(AND(OR(B5=J1;B5=K 1);B8=O1);3;IF(AND(OR(B5=J1;B5=K1);B8=P1 );P3;IF(AND(OR(B5=J1;B5=K1);B8=Q1);Q3;IF (AND(OR(B5=J1;B5=K1);B8=R1);R3;0)))))))

    highlight- - OR.
    IF - ( OR-a) ! ->

    =IF(AND(OR(B5=J1;B5=K1);B8=L1);L3;IF(AND (OR(B5=J1;B5=K1);B8=M1);M3;IF(AND(OR(B5= J1;B5=K1);B8=N1);N3;IF(AND(OR(B5=J1;B5=K 1);B8=O1);3;IF(AND(OR(B5=J1;B5=K1);B8=P1 );P3;IF(AND(OR(B5=J1;B5=K1);B8=Q1);Q3;0) )))))

    ( )... OR , !

    ?

  2. #2
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    Excel 7 .

  3. #3
    pimpirlit's Avatar
    Join Date: Mar:2004
    Location:
    Posts: 21,712
    Quote Originally Posted by ven_stoich View Post
    Excel 7 .
    . - hlookup() ( , ).
    !

  4. #4
    Registered User lisi4ko's Avatar
    Join Date: Nov:2008
    Location: Varna
    Posts: 91
    thnx . hlookup

  5. #5
    pimpirlit's Avatar
    Join Date: Mar:2004
    Location:
    Posts: 21,712


    =IF(OR(B5=J1;B5=K1);HLOOKUP(B8;L1:R3;3;F ALSE);0)

    , B5=J1 B5=K1, B8 L1 R1 ( ) #N/A 0. , -

    =IF(AND(OR(B5=J1;B5=K1);(NOT(ISNA(HLOOKU P(B8;L1:R3;3;FALSE)))));HLOOKUP(B8;L1:R3 ;3);0)
    !

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 |