Results 1 to 7 of 7

Thread: excel ...

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    [OUTFACED] VLADO's Avatar
    Join Date: Aug:2003
    Location:
    Posts: 4,669

    excel ...

    , , .

    IF ,

  2. #2
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,393
    1 1 2
    "=IF(A1=2;"ima 2";"nqma 2")"

    1=""
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

  3. #3
    [OUTFACED] VLADO's Avatar
    Join Date: Aug:2003
    Location:
    Posts: 4,669
    ...

    00319 00511 00609 00619 00625 00631 50307 50309 50313 50382 90601 90604 90606 90607 90688
    50309 ...

    :
    ...

    =IF(ISNUMBER(SEARCH("v",A2)),"OK", "Not OK")
    Checks to see if A2 contain the letter v (OK)

    ... /
    .. , - -
    IF , ...
    Last edited by VLADO; 4th June 2007 at 18:45.

  4. #4
    . 's Avatar
    Join Date: Feb:2006
    Location: .
    Posts: 2,737
    1. ?
    :
    :
    B1 :
    Code:
    =IF(SEARCH("05631";A1)>0;"";"")
    , "", #VALUE!, .
    , .
    2. , ?
    .

    : , ...
    - .

  5. #5
    Registered User
    Join Date: Apr:2005
    Location: Sofia
    Posts: 340
    #VALUE!

    :

    iserror()

  6. #6
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,393
    Quote Originally Posted by VLADO View Post
    ... /
    .. , - -
    IF , ...
    - 2 ( ) 2 . .
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

  7. #7
    [OUTFACED] VLADO's Avatar
    Join Date: Aug:2003
    Location:
    Posts: 4,669

    ( ) ... ... ,

    edit:

    =IF(ISERROR(SEARCH(90601;BS4));IF(ISERRO R(SEARCH(90604;BS4));"00";4);IF(ISERROR( SEARCH(90604;BS4));1;14))

    10 mshbul
    Last edited by VLADO; 5th June 2007 at 12:50.

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 |