Results 1 to 4 of 4

Dragging formulas

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2010
    Location
    Irvine, CA, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Dragging formulas

    Ok so i want to drag a formula however i want one of the values of the formula to change and the other not to change. for example:

    c1=a1+b1
    c2=a1+b2
    c3= a1+b3
    : : :

    how can i make it do this when i drag? a1 is not just a constant and it depends on other parameters.

    please help
    Last edited by gevo12321; 01-29-2010 at 08:53 PM.

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