| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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` |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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` |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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` |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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` |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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` |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart in Excel 2007- Positive & negative value columns | Excel Discussion (Misc queries) | |||
| Columns negative to positive | Excel Discussion (Misc queries) | |||
| how to find negative figure in various columns and rows | Excel Discussion (Misc queries) | |||
| formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
| Text Columns Negative Numbers Upgrade Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
