How do I program the cells in Excel to add, subtract, etc?

B

Bob Mulligan

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

Gord Dibben

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/templates/CT011377141033.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
 
G

Gord Dibben

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/training/CR061831141033.aspx


Gord

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/templates/CT011377141033.aspx

Browse through the Business and Personal sites.

You will get a good idea of layout.


Gord Dibben MS Excel MVP
Click to expand...

Gord Dibben MS Excel MVP
 
S

S S

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.
 
Top