#1
|
|||
|
|||
It has to be simple...formula
I've been beating my head against the wall trying to figure this out. I'm usually smarter that this...
here's what I have, a simple column of numbers that I want to subtract each new input from the top number. It's a weight loss chart and I want to know how much I've lost in total, with additional data being put in daily. For example: A1:Starting weight: 250 A:2 Day one: 248 A:3 Day two: 245 A:4 Day Three: 244 A:5 Day Four: 240 A:6 etc. etc for day A:50 =Current 'total' lost based on A:1 - last day in sequence cumuluative total lost would subract each number in the sequence but only that number from 250. Meaning on day four it would take 250-240 to come up with 10 pounds but on day two it would subtract 245 from 250 to show a loss of 5 pounds. Of course I could wait until the end and just subtract the bottom number from the top, but I want to track it daily.. what am I missing? I feel silly even asking this because the answer is likely so obvious an dI'm over thinking it. So thank you for any help |
#2
|
||||
|
||||
Hi,
In column A keep the days, column B the daily weight and column C the cumulative loss. The cumulative loss equation will be: Code:
=Weight(t-1) - Weight(t) + CumulativeLoss(t-1) Code:
=B2-B3+C2 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Simple or what? | nebb | Publisher | 0 | 09-23-2010 07:00 AM |
Simple template | kieransymes | Word | 0 | 03-08-2010 02:13 AM |
Simple formulas | den hobbelder | Word | 1 | 02-26-2010 01:53 PM |
Simple Envelope Question.... | cmcneill | Word | 0 | 08-17-2009 05:12 PM |
Simple macro undoable? | garon5 | Outlook | 0 | 04-20-2007 10:27 AM |