Re: OT: Excel Calculation

In article <1hlpvt4.wuenow11or0teN%gax.slee@xxxxxxxxxxxx>,
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.

-- tim
.

Relevant Pages

  • Re: OT: Excel Calculation
    ... I'm trying to monitor my electricity usage and thought Excel could help ... me with logging the data. ... Looks like cell C3 contains 34. ...
    (uk.comp.sys.mac)
  • OT: Excel Calculation
    ... To say I'm a novice at Excel is an understatement, ... I'm trying to monitor my electricity usage and thought Excel could help ...
    (uk.comp.sys.mac)
  • Re: Opening Excel file in new window
    ... Thanks for the feedback PapaDos. ... That works and does allow second Workbook to go to second screen, ... I drag the VBE window across to the second monitor, ... Excel files, so I can view code on one screen and what is happening on ...
    (microsoft.public.excel)
  • Re: Opening Excel file in new window
    ... Just fixed it and updated the website info. Check it out again to see what ... That works and does allow second Workbook to go to second screen, ... I drag the VBE window across to the second monitor, ... Excel files, so I can view code on one screen and what is happening on ...
    (microsoft.public.excel)
  • Re: Increase font size within my formula bar
    ... Change the Standard Font Size to something larger ... Then close excel and reopen it. ... I finally replaced my old CRT style monitor whose brightness had gotten ... The monitor recommended 1140 by 900 resolution and I am trying to adapt to ...
    (microsoft.public.excel.programming)