Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Mulligan
 
Posts: n/a
Default How do I program the cells in Excel to add, subtract, etc?

I don't know much about Excel, but I'd like to program the cells for
accounting. How do I do this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default How do I program the cells in Excel to add, subtract, etc?

I suggest you purchase Excel for Dummies to get started.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bob Mulligan" <Bob wrote in message
...
I don't know much about Excel, but I'd like to program the cells for
accounting. How do I do this?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default How do I program the cells in Excel to add, subtract, etc?

You cannot format cells to do math calculations.

You must enter formulas which reference other cells.

A1 contains 123
A2 contains 456

In A3 enter =A1+A2 to get the sum of A1 and A2.

There are many good Accounting Templates available at the MS Template Gallery.

http://office.microsoft.com/en-us/te...377141033.aspx

Browse through the Business and Personal sites.

You will get a good idea of layout.


Gord Dibben MS Excel MVP

On Mon, 1 May 2006 11:25:01 -0700, Bob Mulligan <Bob
wrote:

I don't know much about Excel, but I'd like to program the cells for
accounting. How do I do this?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default How do I program the cells in Excel to add, subtract, etc?

Bob

I would also suggest you have a look at a few on-line tutorials.

Some tutorial sites for basics of Excel........

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

On Mon, 01 May 2006 11:41:08 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

You cannot format cells to do math calculations.

You must enter formulas which reference other cells.

A1 contains 123
A2 contains 456

In A3 enter =A1+A2 to get the sum of A1 and A2.

There are many good Accounting Templates available at the MS Template Gallery.

http://office.microsoft.com/en-us/te...377141033.aspx

Browse through the Business and Personal sites.

You will get a good idea of layout.


Gord Dibben MS Excel MVP

On Mon, 1 May 2006 11:25:01 -0700, Bob Mulligan <Bob
wrote:

I don't know much about Excel, but I'd like to program the cells for
accounting. How do I do this?


Gord Dibben MS Excel MVP
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S S
 
Posts: n/a
Default How do I program the cells in Excel to add, subtract, etc?

Someone will be along soon i am sure but I think you will need to be more
specific "but I'd like to program the cells for
accounting." this is too general a statement.
You might want to try in the meantime a google search for some basic stuff.


"Bob Mulligan" <Bob wrote in message
...
I don't know much about Excel, but I'd like to program the cells for
accounting. How do I do this?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
changing the way Excel displays selected cells P Boric Excel Discussion (Misc queries) 1 July 28th 05 01:09 PM
Hyperlink in Excel opens the right program, but can't read file. Katydid Excel Discussion (Misc queries) 0 May 6th 05 04:16 PM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM
How to make empty cells as zero in excel add-ins for SQL Server an Microlong Excel Worksheet Functions 0 January 12th 05 06:31 AM


All times are GMT +1. The time now is 03:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"