Results 1 to 7 of 7

Inserting row : not all values are changed one stay the same??

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    France
    MS-Off Ver
    Excel 2010
    Posts
    30

    Inserting row : not all values are changed one stay the same??

    Hello everybody, i'm needing your help here as I've got a problem which I don't understand and I'm not able to solve myself.

    I've got rows with complicated formulas and if functions like (on row 82):

    Formula: copy to clipboard
    =$I82+((1/24)*IF($N82=1,IF($N81=2,VLOOKUP($A82,Temps!$K$61:$L$115,2,FALSE),VLOOKUP($A82,Temps!$C$61:$D$115,2,FALSE)),IF($N82=0,0,IF($N82=1.5,VLOOKUP($A82,Temps!$G$61:$H$115,2,FALSE),IF($N82=2,VLOOKUP($A82,Temps!$C$61:$D$115,2,FALSE),0)))))

    No problem with the formula itself but when i insert a line before it, references change as i want to except one! The reference on the previous line.
    See it here (now formula is located on row 83 after inserting):

    Formula: copy to clipboard
    =$I83+((1/24)*IF($N83=1,IF($N81=2,VLOOKUP($A83,Temps!$K$61:$L$115,2,FALSE),VLOOKUP($A83,Temps!$C$61:$D$115,2,FALSE)),IF($N83=0,0,IF($N83=1.5,VLOOKUP($A83,Temps!$G$61:$H$115,2,FALSE),IF($N83=2,VLOOKUP($A83,Temps!$C$61:$D$115,2,FALSE),0)))))

    It should be $N82 here no?

    Why the value in red is not changing? I don't know... If you know a tip to force it to change i'll be so pleased :p

    Thanks!
    Last edited by polooop; 06-20-2014 at 05:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Make a button stay in the same place after inserting a new row.
    By smash96 in forum Excel General
    Replies: 3
    Last Post: 03-27-2014, 07:54 AM
  2. Why is it when i do sort values do not stay the same
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2011, 02:23 PM
  3. Getting values from function to stay on reload
    By McManCSU in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2006, 05:52 PM
  4. Inserting a date when cell is changed
    By Gavin Ling in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2006, 09:25 PM
  5. Replies: 1
    Last Post: 01-23-2005, 10:07 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