Consulting

Results 1 to 3 of 3

Thread: Two different additions alternatively

  1. #1
    VBAX Regular
    Joined
    Aug 2017
    Posts
    57
    Location

    Two different additions alternatively

    I have two values 3 and 4. I would like to add these numbers to A1 alternately as I copy down the previous cell only. So lets A1=1, in the first copy down A2 = A1+3, and the next copy down A3=A2+4, and the next A4=A3+3, etc. it will go on like this. How can we formulate this?

    A1
    A2=A1+3
    A3=A2+4
    A4=A3+3
    A5=A4+4
    ...
    etc..

  2. #2
    Moderator VBAX Master georgiboy's Avatar
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    1,158
    Location
    Maybe one option:

    =IF(ISODD(ROW(A2)),A1+4,A1+3)

    Hope this helps
    Click here for a guide on how to add code tags
    Click here for a guide on how to mark a thread as solved

    Excel 365, Version 2401, Build 17231.20084

  3. #3
    VBAX Regular
    Joined
    Aug 2017
    Posts
    57
    Location
    yes, this is what I need. thanks a lot!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •