| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I did the ABS function for the + and - sum
I entered the suggested ABS function (thank you!) and it worked on those
columns that have a consistent - or + on the number but the columns that have mixed signs show "#value" instead of the sum total of the numbers......any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I did the ABS function for the + and - sum
ABS will return a #Value if it is referencing something other than a number
such as an ascii string 1) Check to make sure there isn't a ' in front of any cells that have numbers. These will be treated as text. 2) highlight the box that is giving the error. Look for the square box with the !. Select show calculations steps to help find where the error is occuring. "slschram" wrote: I entered the suggested ABS function (thank you!) and it worked on those columns that have a consistent - or + on the number but the columns that have mixed signs show "#value" instead of the sum total of the numbers......any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I did the ABS function for the + and - sum
Thanks Joel - I'll try it................I appreciate you taking the time to
answer. "Joel" wrote: ABS will return a #Value if it is referencing something other than a number such as an ascii string 1) Check to make sure there isn't a ' in front of any cells that have numbers. These will be treated as text. 2) highlight the box that is giving the error. Look for the square box with the !. Select show calculations steps to help find where the error is occuring. "slschram" wrote: I entered the suggested ABS function (thank you!) and it worked on those columns that have a consistent - or + on the number but the columns that have mixed signs show "#value" instead of the sum total of the numbers......any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Using the autofill function but increment by certain number in function | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
