| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To get a true sum
Help!
How do I get a true sum? Ex: A1 - 78,661.23 A2 - 3,612.66 A3 - 15,732.25 Total 98,006.13 The true sum should be 98,006.14, but it's giving me .13 instead of .14 -- Keep learning |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To get a true sum
http://www.mcgimpsey.com/excel/pennyoff.html
-- Regards, Peo Sjoblom "shap-er" wrote in message ... Help! How do I get a true sum? Ex: A1 - 78,661.23 A2 - 3,612.66 A3 - 15,732.25 Total 98,006.13 The true sum should be 98,006.14, but it's giving me .13 instead of .14 -- Keep learning |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To get a true sum
How did you get the numbers? Are they the result of some formula, and
you are just displaying them to 2dp? Try increasing the number of decimals that are visible. You could make use of the ROUND function to ensure those intermediate values are accurate. Hope this helps. Pete On Dec 7, 5:08 pm, shap-er wrote: Help! How do I get a true sum? Ex: A1 - 78,661.23 A2 - 3,612.66 A3 - 15,732.25 Total 98,006.13 The true sum should be 98,006.14, but it's giving me .13 instead of .14 -- Keep learning |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if any of 3 conditions is true, then answer is true | Excel Worksheet Functions | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| How do I stop Excel from changing the word true to TRUE? | Excel Discussion (Misc queries) | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
Linear Mode
