Thread: Formulas
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 287
Default Formulas

Normally you wouldn't use SUM(C11+C21), either

=SUM(C11,C21)

or just

C11+C21

but that doesn't explain your problem.....what happens if you press F9, how
is the result cell formatted?

"loveforlife" wrote:

I enter =SUM(C11+C21) C11 is 10000 and C21 is (9000)
My formula result is 0. What gives?
--
loveforlife