| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy a Negative value to another WS
I have a workbook that has more than 1 worksheet. I need to copy figures
from my Input ws to the Posting ws if the cell in the Input sheet is greater than a blank. However, if the value is negative, I also need to to show it as a negative on the Posting sheet. Following is the formula I am using, however, a negative number is showing as a positive on the Posting sheet. How can I correct this? =IFBLANK(Input!E7)," ",ABS(Input!E7)) Any help would be appreciated -- Linda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Threaded Mode
