+ Reply to Thread
Results 1 to 3 of 3

Fix the formula to constant cell

  1. #1
    Registered User
    Join Date
    08-02-2010
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post Fix the formula to constant cell

    Hello,

    In the attached sheet, i need to help on the formula with column "L"
    I want to copy paste the formula L3 till the end of the column, but need the constant cell in the formula to change to after the blank row.

    So formula =((F3-$J$1)/7-(SUM(M$2:M2))) should change to =((F3-$J$1)/7-(SUM(M$6:M2))) after the blank cell and so on .... without manually going and changing the M$

    I have attached the workbook with 2 sheets. Expiry (2) is the one what happens when i copy paste the formula till end, then i have to manually go and change formula to get result which is in Expiry (1)

    Is is possible to fix the cell in formula after blank row or some other work around to get the same result in Expiry (1)
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Fix the formula to constant cell

    Deleted by GK. Formula incompatible with Excel 2007 (version used by Poster).
    Glenn



  3. #3
    Registered User
    Join Date
    08-02-2010
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Re: Fix the formula to constant cell

    Thanks Glenn, it worked.
    I will dissect it to understand more.

+ 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] Using a constant cell in a formula
    By dave217 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2020, 11:18 AM
  2. [SOLVED] How To Keep Formula Cell Reference Constant ?
    By Mr.Castle in forum Excel General
    Replies: 5
    Last Post: 03-03-2019, 03:01 PM
  3. Need Help making the formula in a Cell Constant
    By balu.soln4biz in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 06-05-2014, 05:14 PM
  4. [SOLVED] Replicating a formula with a constant cell within it
    By Ray1001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2013, 04:10 PM
  5. [SOLVED] How do I keep one cell constant in a formula even when copying
    By excel rookie in forum Excel General
    Replies: 3
    Last Post: 04-26-2006, 02:30 PM
  6. Replies: 2
    Last Post: 12-14-2005, 09:40 PM
  7. [SOLVED] keep a cell used in a formula constant when pasteing into another.
    By Rob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2005, 04:06 PM

Tags for this Thread

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