How do I make cells subtract?
 

I'm only new to Excell.
I'm setting up a Car log book in excell. I need to keep track of Klm's (Miles)
I entered in my start and finnish klm's, Now I would like the 3rd cell to
subtract the total number of Klm's travelled for the day e.g:start 1111
finish 1256 total 145. How can I do this. Thank you.

How do I make cells subtract?
 

A1 B1 C1
Start END Miles
1111 1256 =B1-A1

Mike


"Robert" wrote:

I'm only new to Excell.
I'm setting up a Car log book in excell. I need to keep track of Klm's (Miles)
I entered in my start and finnish klm's, Now I would like the 3rd cell to
subtract the total number of Klm's travelled for the day e.g:start 1111
finish 1256 total 145. How can I do this. Thank you.

How do I make cells subtract?
 

I suggest you buy a books on Excel. The books are available at Barnes and
Noble and also Amazon.com

The starter books are Excel 2003 Step by Step (ISBN: 0-7536-1518-7), $24.99
and Excel 2007 (ISBN: 0-7356-2304-X), $24.99
Both books by Curtis Frye are about 300 pages. The Step by Step books are
mandatory reading for beginners in Excel.

Then you should buy Microsoft Office Excel 2003 Bible (ISBN: 0-7645-3967-1),
$39.99 or Microsoft Office Excel 2007 Bible (ISBN: 0-4700-4403-9), $39.99.
Both books by John Walkenbach are about 900 pages.

You should also take advantage of the following web sites:
John Walkenbach's The Spreadsheet Page: http://www.j-walk.com/ss.
Chip Pearson's Pearson Software Consulting:
http://www.cpearson.com/excel.htm.
Stephen Bullen's Excel Page: http://www.bmsltd.co.uk/excel
David McRitchie's Excel Pages
http://www.mvps.org/dmcritchie/excel/excel.htm.
Jon Peltier's Excel Page: http://peltiertech.com/Excel/Charts/index.html
For charts
Spreadsheet FAQ (Frequently Asked Questions):
http://www.faqs.org/faqs/spreadsheets/faq This site is filled with links for
Excel.


----- Original Message -----
From: "Robert"
Newsgroups: microsoft.public.excel.worksheet.functions
Sent: Wednesday, July 18, 2007 12:34 AM
Subject: How do I make cells subtract?


I'm only new to Excell.
I'm setting up a Car log book in excell. I need to keep track of Klm's
(Miles)
I entered in my start and finnish klm's, Now I would like the 3rd cell to
subtract the total number of Klm's travelled for the day e.g:start 1111
finish 1256 total 145. How can I do this. Thank you.

"Robert" wrote in message
...
I'm only new to Excell.
I'm setting up a Car log book in excell. I need to keep track of Klm's
(Miles)
I entered in my start and finnish klm's, Now I would like the 3rd cell to
subtract the total number of Klm's travelled for the day e.g:start 1111
finish 1256 total 145. How can I do this. Thank you.

How do I make cells subtract?
 

Start number 1111 in A1

Finish number 1256 in B1

In C1 enter =B1-A1 returns 145

Here are a few basic tutorials for Excel to get a beginner going.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Wed, 18 Jul 2007 00:34:21 -0700, Robert wrote:

I'm only new to Excell.
I'm setting up a Car log book in excell. I need to keep track of Klm's (Miles)
I entered in my start and finnish klm's, Now I would like the 3rd cell to
subtract the total number of Klm's travelled for the day e.g:start 1111
finish 1256 total 145. How can I do this. Thank you.