|
|
#3
09-07-2012, 01:06 AM
|
|||
|
|||
OK, there is more. Even though the sum if of numbers with only two decimal places, the sum itself is 8805.13000000001 !!!
So the only way I can get a correct result is by using TRUNC(SUM(G2:G261),2). Weird, as I have several worksheets all very similar, but only this one produces this odd result. Thanks Bill!!! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to release hard returns?
|
markg2 | Word | 13 | 05-08-2023 01:38 PM |
| Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
|
No tabbing, no returns in forms?
|
rdowney1 | Word | 7 | 06-29-2012 08:35 AM |
| Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
| IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |
Windows 7 32bit 
Office 2007
Threaded Mode