Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I have a column "G" with negative numbers, positive numbers and zero's. Column "H" is the column that adds up all the negative numbers from column "G" . When there is a positive number greater than zero i need column "H" to show a zero from the corresponding cell in column "G" e.g G H -5.0 5.0 -5.0 10.0 -5.0 15.0 22.5 0.0 0.0 0.0 0.0 0.0 -7.0 7.0 42.5 0.0 -7.0 7.0 -8.0 15.0 -6.0 21.0 0.0 0.0 5.5 0.0 -12.5 12.5 -20.0 32.5 -8.0 40.5 There is a empty row between each set of three entrie's Could any one help me with this please regards bill -- bill gras |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
negative numbers | Excel Discussion (Misc queries) | |||
"find and replace" negative numbers | Excel Worksheet Functions | |||
How do I replace negative numbers with zero in Excel. | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
Add sequences of positive then negative numbers | Excel Discussion (Misc queries) |