| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| There's no export to dbf files from XL2007? | Excel Discussion (Misc queries) | |||
| XL2007 and array of sheet names? | Excel Discussion (Misc queries) | |||
| How do I keep fixed and Non-fixed decimals on a sheet together? | Excel Worksheet Functions | |||
| drawdown at fixed rate over set period from investment at fixed % | New Users to Excel | |||
| excel macro inconsistency | Excel Discussion (Misc queries) | |||
Threaded Mode
