>
> So it would be as simple as...
>
# Of Transactions = 250
100 Transactions @ $60 = $6,000 x Billing Rate of .003 = $18 Fee
150 Transactions @ $40 = $6,000 x Billing Rate of .002 = $12 Fee
Total Fees = $30
--
# Of Transactions = 50
25 Transactions @ $60 = $1,500 x Billing Rate of .005
I need to solve a problem and I need help with the IF:THEN:ELSE calculation
please.
I need to create a spreadsheet where this is the model and calculate costs.
IF(TRANSACTION) IS MORE THAN $50, AND UNDER 100 TRANSACTIONS TOTAL, BILLING
RATE IS .005
IF(TRANSACTION) IS LESS THAN $50, AND UNDER
Sub longfunction()
Dim varArray
varArray = Worksheets("Sheet2").Range("A1:A1000").Value2
Do
For Each Str In varArray
If InStr(1, Selection, Str) > 0 Then Selection.EntireRow.Delete
If InStr(1, UCase(Selection), Ucase(Str)) > 0 Then
Selection.EntireRow.Delete
Next
Selection.Offset(1, 0).Select
L
In my excel sheet, I have an array but the amount of entries is close to 1,000
separate items. I am limited to 255 / too many line continuations.
Would calling a file or creating a dictionary/collection be best to implement
into the array?
Sub longfunction()
Dim Rng As Range, Str
Ra
In my excel sheet, I have an array but the amount of entries is close to 1,000
separate items.
Would calling a file or creating a dictionary/collection be best to implement
into the array?
Sub longfunction()
Dim Rng As Range, Str
Range("A1").Select
Do
For Each Str In Array
Tuesday, August 6, 2013 10:35:01 PM UTC-4, De Premor wrote:
>
> Try to change to Uppercase or Lowercase the test string and the sentences
>
> In Ex:
> If InStr(1, UCase(Selection), Ucase(Str)) > 0 Then
> Selection.EntireRow.Delete
>
>
> Pada 06/08/2013 23:41, Spencer
Aside from the crazy windings text, that did the trick! Thank you so much!
Is there a way to make is so that case does not matter?
"Curves"
"curves"
"CURVES"
So they all get deleted?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offi
I am trying to make a macro that deletes a row in a column if it detects a
specific word or phrase from a set of phrases.
"Friendly's"
"Ruth's Chris Steak House"
"Hooters"
"Ruby Tuesday"
"Chili's Grill & Bar"
etc.
I have searched for HOURS to find an answer and have tried combining code
