View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default XL2003 inconsistency fixed in XL2007?

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.