excel 2011 mac 'sum formula' returns zero

June 14, 2011 at 11:32:14
Specs: Macintosh
It will add intergers, but not decimal numbers i.e. =sum(0.5+0.6) results in 0,00

See More: excel 2011 mac sum formula returns zero

Report •

June 14, 2011 at 12:10:06
Works on my Windows XP running Excel 2007.

=sum(0.5+0.6) result 1.1



Report •

June 14, 2011 at 12:10:36
Check the properties of the cell (General, Currency, Number). Since a formula is in the cell, you may have to assign it to a number type.

Report •

June 14, 2011 at 18:33:32
re: "...results in 0,00"

Is it really returning zero comma zero zero?

If so, it sounds like a formatting issue.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question