Microsoft Office Forums - View Single Post - [Solved] It has to be simple...formula

Thread: [Solved] It has to be simple...formula

View Single Post

Old

03-04-2011, 01:06 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

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)

Please see the attached example. In our example, that equation translates to this formula:

Code:

=B2-B3+C2

Attached Files

Book1.xlsx (9.0 KB, 10 views)

Reply With Quote