Results 1 to 7 of 7
Thread: Excel
Hybrid View
-
8th September 2022 15:51 #1Registered 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 ?
-
8th September 2022 15:54 #2
VLOOKUP . IF-, ,
-
8th September 2022 16:01 #3
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
-
8th September 2022 16:37 #4
, :
Sheet "" - , , .
, ( ) . :
- 15%
- 20%
- 25%
() - 10%
B1 Data-Validation "".
- C1 - , VLOOKUP. VLOOKUP B1 "" .
, , D1 - A1 C1.
- - ., , , .: ( ) - (); (..) - (..).
-----! , ...
-
8th September 2022 23:49 #5Registered 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
-
9th September 2022 00:26 #6




Reply With Quote
LOG
06.05.23 ., 12:03 in