+ Reply to Thread
Results 1 to 2 of 2

Changing cell above formula

  1. #1
    Forum Contributor
    Join Date
    01-03-2016
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    2016
    Posts
    125

    Changing cell above formula

    I have this code where I get the entire value from a division (for example, 50/3 = 16,67, not 16). But when try to work with 4 different cells (Ex/Fx and Gx/Hx, x as the last row number), for example (as the images below) If fill Ex and Fx (so Ix would be =SUM(QUOTIENT(Ex, Fx),(MOD(Ex,Fx)/Fx))) once, fill it twice (on the row above) and then try to fill Gx/Hx (so Ix should be =SUM(QUOTIENT(Gx,Hx),(MOD(Gx,Hx)/Hx))), it changes the value from the cell above, I mean, if it the cell above was =SUM(QUOTIENT(E3, F3),(MOD(E3,F3)/F3)) it will be =SUM(QUOTIENT(G3, H3),(MOD(G3,H3)/H3)).

    What can I do to fix it? I guess it's a excel's thing. I don't know if can be fixed by excel settings or even do it with VBA.

    6exlaZU.png
    owVGoTf.png
    NCUYqaw.png

    Please Login or Register  to view this content.
    I tried to use ISEMPTY (using with both group of cells, Ex/Fx and Gx/Hx), but it didn't work either.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    01-03-2016
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    2016
    Posts
    125

    Re: Changing cell above formula

    After some weeks, I, accidentally, found a solution. It's pretty much a excel's "problem". I had to deactivate one AutoCorrect option.

    Please Login or Register  to view this content.

+ 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. Replies: 5
    Last Post: 11-24-2015, 11:33 PM
  2. Changing a formula cell to a standard cell on double click.
    By Zookopf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2015, 11:54 AM
  3. Replies: 4
    Last Post: 03-15-2014, 11:01 PM
  4. formula cell column and row number changing when populating thenext cell row
    By PROENGINEER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2014, 03:43 PM
  5. copy formula down entire column while changing formula cell reference
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 11:34 AM
  6. [SOLVED] How to copy formula's from a Relative cell without changing the cell references
    By mowens74 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-03-2013, 04:42 AM
  7. Replies: 5
    Last Post: 08-10-2012, 04:32 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