negative columns

[gonzoandchickens]

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`

 

[Jacob Skaria]

-200

If this post helps click Yes

 

[FARAZ QURESHI]

Try 1904 type date format:

Tools>Options>Calculation

 

[David Biddulph]

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

 

[gonzoandchickens]

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