| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Totalling discrepancies
The ABS fuction returns the Absolute Value of a number. Basically, it just
strips off any negative signs, treating all numbers as positve. The use of an Array Formula, tells Excel to apply the function (in this case, ABS) to each individual cell in the range, rather than to the range as a whole. HTH, Elkar "fodman" wrote: Excellent, works perfectly. Could you please explain that Formula? -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=552422 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum hours and minutes totalling over 24 hours? | Excel Worksheet Functions | |||
| Totalling numbers that are Conditionally Formatted | Excel Discussion (Misc queries) | |||
| Totalling lists | Excel Discussion (Misc queries) | |||
| Totalling unique values | Excel Discussion (Misc queries) | |||
| Totalling workbooks | New Users to Excel | |||
Threaded Mode
