Results 1 to 7 of 7

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Sep:2022
    Location: Plovdiv
    Posts: 2

    Excel

    !

    : % . : 1=100, B1=tekst, C1=A1*0,1 - 10%. B1, % 0 , 10%. , 0, B1 15-20 .
    IF, 1 . 15 ?


  2. #2
    . haibusa2005's Avatar
    Join Date: Mar:2005
    Location:
    Posts: 1,883
    VLOOKUP . IF-, ,

  3. #3
    Registered User AssassiN's Avatar
    Join Date: Nov:2005
    Location: Sofia
    Posts: 2,142
    IF- , .
    SWITCH, .
    GB B550 AORUS Elite AX V2; Ryzen5 5600x+Noctua U14s; 6800xt Red Devil; 2x16GB Corsair LPX@3600; Corsair AX1600i; Corsair 780T; Dell G3223D

  4. #4
    The point of no return ifch0's Avatar
    Join Date: Jun:2007
    Location:
    Posts: 3,678
    , :

    Sheet "" - , , .

    , ( ) . :
    - 15%
    - 20%
    - 25%
    () - 10%

    B1 Data-Validation "".
    - C1 - , VLOOKUP. VLOOKUP B1 "" .
    , , D1 - A1 C1.

    - - .
    , , , .
    : ( ) - (); (..) - (..).
    -----! , ...

  5. #5
    Registered User
    Join Date: Mar:2009
    Location:
    Posts: 26
    MyDiscount, 0 Item xText 0,1 .

    :
    1="text1" , MyDiscount(A1)=0
    2="text2sdd" , MyDiscount(A2)=0
    3="text" , MyDiscount(A3)=0.1

    text1, text2 . .

    , .



    Function MyDiscount(xText As String) As Variant
    Item = Array("text1", "text2", "text3", "text4")
    For i = LBound(Item) To UBound(Item)
    If InStr(1, xText, Item(i)) <> 0 Then
    MyDiscount = 0
    Exit Function
    Else
    MyDiscount = 0.1
    End If
    Next i
    End Function

  6. #6
    XIIID's Avatar
    Join Date: Oct:2004
    Location:
    Posts: 70
    , -?!

    =IF(ISERROR(MATCH(B1,A:A,0)),10%,0%)

    ( A - , B1 - )

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 |