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

In spite of the format for j82 and k82, the contents may be text. Try
=j82&k82.

"Eric" wrote:

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?