XL2003 inconsistency fixed in XL2007?
Still the same in Excel2007
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"joeu2004" wrote in message oups.com...
| Using Office Excel 2003, if A1 contains ="", SUM(A1) returns 0, but
| ROUND(A1,0) returns #VALUE!. I prefer the SUM result. Has ROUND (et
| al) been fixed in Excel 2007?
|
| By the way, SUM("") returns #VALUE!. So even SUM is not consistent
| with itself. Sigh.
|
|