Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Negative Number column
I am trying to make a column product negative numbers when I manually enter
them in a spreadsheet. I am using a simple sum formula to add across rows (10 columns) and the first column should always be a negative number i.e credit and the rest positive. I am real new to excel so I must be doing something wrong. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Negative Number column
Assuming the 10 cols are A to J,
maybe a simpler way would be to use something like .. In K1: =SUM(B1:J1)-A1 Or, in K1: =SUM(B1:J1,-A1) with K1 copied down Then you could just enter the credit numbers in the first column "as-is", w/o worrying about making these negative -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "go" wrote in message ... I am trying to make a column product negative numbers when I manually enter them in a spreadsheet. I am using a simple sum formula to add across rows (10 columns) and the first column should always be a negative number i.e credit and the rest positive. I am real new to excel so I must be doing something wrong. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the last number in a column | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How do I sort a column a unique number? | Excel Worksheet Functions | |||
How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) |