+ Reply to Thread
Results 1 to 4 of 4

Cell fixing

  1. #1
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Cell fixing

    Dear all

    I need a help. I want to drag this formula down to get the value.
    =I3-('[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$B$3+'[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$B$4*U3)

    However, I would like to change the formula

    =D4-('[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$C$3+'[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$C$4*P4)

    =D5-('[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$D$3+'[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$D$4*P5)

    When I drag down, want the cell to be changed from B to C to D. Please help me.

    Regards
    Shams

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Cell fixing

    Hi,

    That bit would be fairly straightforward. I'm a little concerned, however, that the I3 and U3 in the original formula have become, respectively, D4, D5 and P4, P5 etc. Is this a typo, or something that needs working in to the formula?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Cell fixing

    Hi Xor LX

    I have solved the problem by re-organising the data from horizontal to vertical. It now works. Thank you very much for your time.

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Cell fixing

    Glad you got it to work, and thanks for letting us know in any case.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cell Comments - fixing location relevant to the cell
    By TC1980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2013, 01:11 PM
  2. Fixing Cell values
    By Chutney in forum Excel General
    Replies: 1
    Last Post: 10-12-2010, 05:59 PM
  3. Fixing Cell Postions in A Formula
    By scotfitz in forum Excel General
    Replies: 1
    Last Post: 07-09-2008, 03:42 PM
  4. Fixing multiline cell
    By TonyL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2006, 09:20 AM
  5. [SOLVED] `fixing“ a cell
    By [email protected] in forum Excel General
    Replies: 9
    Last Post: 03-02-2006, 02:25 PM

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