negative columns
 

I hope that someone can help,
Using excel 2003 I have a workbook that is set up to show daily takings in
each department within my shop.
I have just introduced a refund department and want to enter these figures
as a negative. Columns A-M are positve and N is the negative O is my
total.....how do I do this???????????????
I know the bare basics of excel!!!
many thanks
martin`

negative columns
 

-200

If this post helps click Yes
---------------
Jacob Skaria


"gonzoandchickens" wrote:

I hope that someone can help,
Using excel 2003 I have a workbook that is set up to show daily takings in
each department within my shop.
I have just introduced a refund department and want to enter these figures
as a negative. Columns A-M are positve and N is the negative O is my
total.....how do I do this???????????????
I know the bare basics of excel!!!
many thanks
martin`

negative columns
 

Try 1904 type date format:

ToolsOptionsCalculation

"gonzoandchickens" wrote:

I hope that someone can help,
Using excel 2003 I have a workbook that is set up to show daily takings in
each department within my shop.
I have just introduced a refund department and want to enter these figures
as a negative. Columns A-M are positve and N is the negative O is my
total.....how do I do this???????????????
I know the bare basics of excel!!!
many thanks
martin`

negative columns
 

If you do, as you say, enter the figures in N as negative, then your total
is just =SUM(A1:N1)
If you put the figures in N as positive, then the total is =SUM(A1:M1)-N1
--
David Biddulph

gonzoandchickens wrote:
I hope that someone can help,
Using excel 2003 I have a workbook that is set up to show daily
takings in each department within my shop.
I have just introduced a refund department and want to enter these
figures as a negative. Columns A-M are positve and N is the negative
O is my total.....how do I do this???????????????
I know the bare basics of excel!!!
many thanks
martin`

negative columns
 

Many thanks!
simple when you know how!
muchly ta
martin

"David Biddulph" wrote:

If you do, as you say, enter the figures in N as negative, then your total
is just =SUM(A1:N1)
If you put the figures in N as positive, then the total is =SUM(A1:M1)-N1
--
David Biddulph

gonzoandchickens wrote:
I hope that someone can help,
Using excel 2003 I have a workbook that is set up to show daily
takings in each department within my shop.
I have just introduced a refund department and want to enter these
figures as a negative. Columns A-M are positve and N is the negative
O is my total.....how do I do this???????????????
I know the bare basics of excel!!!
many thanks
martin`