It has to be simple...formula

		Microsoft Office Forums > Microsoft Excel > Excel
It has to be simple...formula

03-04-2011, 01:06 PM

Colin Legg Colin Legg is offline

Windows 7 32bit It has to be simple...formula

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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)

Other Forums: Access Forums

All times are GMT -7. The time now is 05:05 PM.