| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have a column of numbers, some negative, some positive
I have some calulations in my worksheet. They are done twice, if my
number is positive or negative. I need to fill the cell next to my number with the calulation that correspondes with the + or - of my number. if A1 + if A1 - A1 B1 C1 D1 -10 7 12 A2 B2 C2 D2 14 4 6 I need the 12 to appear in B1. and the 4 to appear in B2. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a column of numbers from positive to negative? | Excel Discussion (Misc queries) | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| column of negative numbers into positive numbers | Excel Worksheet Functions | |||
| Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
| How do I change a column of 500 numbers from positive to negative | Excel Discussion (Misc queries) | |||
![Skip[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
