B
benkyo11
Greetings,
I am trying to create a schedule of values for work. On this schedule
I want to track hours used in three columns: 1) past used, 2) curren
usage, and 3) total used. Past will olny be calculated when a ne
number is inputed into "Current Usage." So, for example, in the firs
bill period, current usage is 25 hours. So, by putting 25 hours i
column 2, column 3 is also updated to 25 hours. In the second billin
period, current usage is 30 hours. When 30 hours is put into column 2
column 1 becomes 25 (from previous period) and column 3 becomes 5
hours. I got this to generally work with a simple IF function i
column 1 that looks like this: =IF((C2-B2)<0,0,C2), this worked great.
However, here is where my question/problem arises. If I start makin
another row to track hours for something else, columns 1 and 3 of m
initial tracking keeps updating. Even if I am working on something i
another excel file, if I enter something and hit "enter," or hi
"delete," my initial functions for columns 1 and 3 keep updating.
cannot seem to figure this out. Please help me.
Benky
I am trying to create a schedule of values for work. On this schedule
I want to track hours used in three columns: 1) past used, 2) curren
usage, and 3) total used. Past will olny be calculated when a ne
number is inputed into "Current Usage." So, for example, in the firs
bill period, current usage is 25 hours. So, by putting 25 hours i
column 2, column 3 is also updated to 25 hours. In the second billin
period, current usage is 30 hours. When 30 hours is put into column 2
column 1 becomes 25 (from previous period) and column 3 becomes 5
hours. I got this to generally work with a simple IF function i
column 1 that looks like this: =IF((C2-B2)<0,0,C2), this worked great.
However, here is where my question/problem arises. If I start makin
another row to track hours for something else, columns 1 and 3 of m
initial tracking keeps updating. Even if I am working on something i
another excel file, if I enter something and hit "enter," or hi
"delete," my initial functions for columns 1 and 3 keep updating.
cannot seem to figure this out. Please help me.
Benky