View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default I'm going crazy, Excel returns 0 for a simple sum

all i am trying to do is add j82 and k82 excel is returning a value of 0.
First i thought the formula was incorrect =j82+(k82/100) but that was not it.
Next i check the format of what's being added, they were all set to number,
no problem there. Next I Evaluate Formula this is where i am losin my mind it
steps me through the process
=J82+(K82/100)
=12243+(K82/100)
=12243+(72/100)
=12243+(0.72)
=12242+0.72
=0.00
There is no error sign nothing. Can any one help?