Search:

Type: Posts; User: Finalfight40; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    16
    Views
    499

    Re: How to calculate compound interest?

    Also i just want to add something else you said which either i misunderstood or James missed.

    For your newest example did you want to add 10% interest AND an extra $10 each week?
  2. Replies
    16
    Views
    499

    Re: How to calculate compound interest?

    Can you not use the same idea provided in the link by Special-k99?

    Where you have

    =A1*(1+B1)^C1

    where A1 is the initial value
    B1 is the interest
    C1 is the number of weeks
  3. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    Thank you for your help and time with this Peter. It seems this has now resolved my issue.
  4. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    I have created a new spreadsheet so that i can replicate the issue and share it with you. I have uploaded it to dropbox and this link is:
    ...
  5. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    Hi Peter

    The only thing i added was something like:


    Range("G1").select
    Range("F1").select

    at the end just so that it would run the on worksheet change event (or one of the events)...
  6. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    Just a follow up, it looks to be happening on tables which are empty.
  7. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    Hi Peter

    i have just found that on some sheets i am receiving a run time error '91' and the line that is being highlighted is:


    .Value = Evaluate(Replace("if(#="""","""",#+7)", "#", .Address))...
  8. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    Thank you Peter. This works perfectly for me at the moment, i will let you know if i run into any issues.

    I was unaware the 1 element and no elements were going to be relevant.

    As for the...
  9. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    Hi Norie and all

    I have had an run time error '91'.

    I believe this is where the tables are currently empty.

    I want to expand and mention that these tables can have nothing in them. Also the...
  10. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    Hi Peter

    For one of my tables i got an error which was :

    Paste method of range class failed and i have changed to red above where this error was received.

    Also i am going to explain a little...
  11. Replies
    17
    Views
    357

    Re: VBA - With each table on Activesheet

    o Norie.

    Thank you so much this works perfectly.

    I haven't had any experience with tables in VBA so i really appreciate it.
  12. Replies
    17
    Views
    357

    VBA - With each table on Activesheet

    Hi

    I am trying to set something up in VBA where it would cycle through each table on the Activesheet and if the 3rd column header says "Start Date" then add 7 for each element on the 3rd column of...
  13. Replies
    2
    Views
    63

    Re: Contatenate with blanks

    Something like this?

    =IF(OR(B1="", C1=""), "", B1 & " " & C1)
  14. Re: Sum Largest Negative and Positive Question

    In your example wouldn't the largest possible sum be 4 since 7 + (-3) = 4

    and also the largest negative sum be -5 since (-2) + (-3) = -5 ?

    if so try:

    =MAX(A1, A1:A5+A2:A6)

    and
  15. Replies
    7
    Views
    179

    Re: How to get sum to jump 3 columns

    After re reading i noticed you wanted to drag right, not down:

    =SUM(OFFSET(Sheet1!$A$20:$C$20,,3*(COLUMNS($A$1:A1)-1)))
  16. Replies
    7
    Views
    179

    Re: How to get sum to jump 3 columns

    Sorry just noticed i slightly misread your post
  17. Replies
    7
    Views
    179

    Re: How to get sum to jump 3 columns

    =SUM(OFFSET(Sheet1!$A$20:$C$20,,3*(ROWS($A$1:A1)-1)))

    Does this do what you want assuming your data is in A20:C20 on sheet 1?
  18. Re: Issue getting the value from an array instead of index

    It's always the way haha.
  19. Re: Issue getting the value from an array instead of index

    Like this?


    Sub GetOutPut()


    Dim V1, V2, V3, V4, V5
    Dim TheList
    Dim output
  20. Replies
    0
    Views
    473

    Google Sheets - Script Dates

    Hi All


    I am having a problem with making a script. I am making a script that will delete a row a week after something has been approved.

    As of right now i have this which when a dropdown...
  21. Re: enter 1 if cell is negative number, zero if positive

    how about:

    =IF(G1<0, 1, 0)

    although are you counting 0 as positive or negative?
  22. Re: Concatenate question to remove a period (everything but this already figured out)

    Its from your mid function i believe. You can change it to:

    =concatenate("+1",left(N2,3),"",mid(N2,5,3),"",right(N2,4))

    but i would just use:

    ="+1" & SUBSTITUTE(N2, ".", "")
  23. Replies
    7
    Views
    138

    Re: Excel Help, nested formulas

    Like this?

    =IF(T2=0,IF(ISNUMBER(SEARCH("Redemption",E2)),"Redemption",IF(ISNUMBER(SEARCH("Subscription",E2)),"Subscription",)),"Exchange"&IF(ISNUMBER(SEARCH("Index",P2))," - Index",""))
  24. Re: How to calculate the median of sums ignoring zeros?

    Is this what you are after?

    =IF(OR(SUM(A1:A2)=0, SUM(A3:A4)=0), SUM(A1:A4), MEDIAN(SUM(A1,A2),SUM(A3,A4)))
  25. Replies
    3
    Views
    86

    Re: Extract value between parentheses

    How about:

    =MID(A2, SEARCH("(", A2)+1, SEARCH(")",A2)-SEARCH("(", A2)-1)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4