Re: OT: Excel Calculation
- From: black.hole@xxxxxxxxxxxxxxx (Jon B)
- Date: Fri, 15 Sep 2006 18:21:18 +0100
Tim Streater <tim.streater@xxxxxxxxxxxx> wrote:
In article <1hlpvt4.wuenow11or0teN%gax.slee@xxxxxxxxxxxx>,And in column four put =D2+C3 , and fill down...
gax.slee@xxxxxxxxxxxx (Gareth Slee) wrote:
To say I'm a novice at Excel is an understatement, tonight is the first
time I've tried to use it...
I'm trying to monitor my electricity usage and thought Excel could help
me with logging the data.
This is the data I've manually entered. so far.
Date Meter Daily Use Total
14/9/06 87355 0 0
15/9/06 87389 34 34
16/9/06 87410 21 55
17/9/06 87450 40 95
How can I get Excel to do the calculations in column 3 and 4
automatically?
Looks like cell C3 contains 34. Enter =B3-B2 in that cell. If you then
click on C3 and do "Fill down", (on Edit menu) it should put appropriate
formulae in those cells.
(these numbers will change if the columns move though)
--
Jon B
Above email address IS valid.
<http://www.bramley-computers.co.uk/> Apple Laptop Repairs.
.
- References:
- OT: Excel Calculation
- From: Gareth Slee
- Re: OT: Excel Calculation
- From: Tim Streater
- OT: Excel Calculation
- Prev by Date: Re: Oh dear, help please...
- Previous by thread: Re: OT: Excel Calculation
- Next by thread: External monitor not working correctly
- Index(es):
Relevant Pages
|
|
