N
Nige
Hi all.
I have a formula query which I'm stuck on, and am hoping for help. Details
as follows:
I have set up a spreadsheet to keep track of weightwatchers diet points
usage, with each day on a different sheet.
On each sheet I have one cell with the total points used on that day, and
another with the total points remaining to be used. So far so simple.
I also have a cell set aside for showing the weekly cumulative points
balance (plus or minus) based upon whether any daily points usage is above
or below the limit. Thus, if Day 1 is 2 points over the limit, Day 2 is 3
points under and Day 3 is 4 points over (naughty!), the Weekly Cumulative
Points Balance cell on Day 4 will show a figure of -3 (for being
cululatively 3 points over the limit).
Still with me? Hope so.
Now, what I'd like is for that cululative figure to show the plus or minus
figure, but with my limited knowledge of formulas I only seem able to link
it to the cell on each sheet showing the points remaining to be used. Thus,
at the beginning of Day 4, the actual figure my cell displays is 22 (based
upon 25 being the daily limit, which at the beginning of Day 4 has been
untouched as points still remaining, but with the -3 cumulative figure
included to leave a total of 25-3=22).
I would like each day to show the plus or minus total cululatively so far,
but not to include each future day's points remaining total, but I'm foxed.
So, if any of you understood this ridiculous explanation, and if any of you
have a possible solution (other than to switch to a simpler diet
program!)...please let me know. It must be possible - Excel formaulas can do
just about anything, after all - but I'm all done in.
Many thanks in advance, and apologies for the length of the post.
Nigel.
I have a formula query which I'm stuck on, and am hoping for help. Details
as follows:
I have set up a spreadsheet to keep track of weightwatchers diet points
usage, with each day on a different sheet.
On each sheet I have one cell with the total points used on that day, and
another with the total points remaining to be used. So far so simple.
I also have a cell set aside for showing the weekly cumulative points
balance (plus or minus) based upon whether any daily points usage is above
or below the limit. Thus, if Day 1 is 2 points over the limit, Day 2 is 3
points under and Day 3 is 4 points over (naughty!), the Weekly Cumulative
Points Balance cell on Day 4 will show a figure of -3 (for being
cululatively 3 points over the limit).
Still with me? Hope so.
Now, what I'd like is for that cululative figure to show the plus or minus
figure, but with my limited knowledge of formulas I only seem able to link
it to the cell on each sheet showing the points remaining to be used. Thus,
at the beginning of Day 4, the actual figure my cell displays is 22 (based
upon 25 being the daily limit, which at the beginning of Day 4 has been
untouched as points still remaining, but with the -3 cumulative figure
included to leave a total of 25-3=22).
I would like each day to show the plus or minus total cululatively so far,
but not to include each future day's points remaining total, but I'm foxed.
So, if any of you understood this ridiculous explanation, and if any of you
have a possible solution (other than to switch to a simpler diet
program!)...please let me know. It must be possible - Excel formaulas can do
just about anything, after all - but I'm all done in.
Many thanks in advance, and apologies for the length of the post.
Nigel.