+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Applying same formula after nth rows with skipping some rows in between

  1. #1
    Registered User
    Join Date
    03-17-2011
    Location
    Vellore,India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Applying same formula after nth rows with skipping some rows in between

    I want to apply same formulas in a particular row after jumping some rows.For example
    particle 1 will give new particle 1' when N4 =0.5*(c4+50) but N5 =0.5*(c5+0)..

    Similarly N12=0.5*(c12+50)..But N13 =0.5*(c13+0)..


    Can anyone plese help me how to copy formula from N4 to N12 without including N5.

    I have also attached th jpg file..Please Help!!!!!!!!

    PARTICLE 1


    X 50 90 Y 50 0 0
    0 60 0 100 50




    PARTICLE 2


    X 0 140 Y 0 0 0
    0 60 50 100 50




    PARTICLE 3

    X 60 80 Y 0 60 0
    0 60 50 40 50
    Attached Images Attached Images
    Last edited by scorpionshash; 03-17-2011 at 09:20 AM. Reason: Better understanding

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Applying same formula after nth rows with skipping some rows in between

    Hi,

    Try this:

    1. Select cells N4 and N5.

    2. Click the copy button (or use Ctrl-C).

    3. Select cell N12.

    4. Click the paste button (or use Ctrl-V).

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    03-17-2011
    Location
    Vellore,India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Applying same formula after nth rows with skipping some rows in between

    Thank you so much!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1