numbers derived from @ right function don't add

  • Thread starter Thread starter april
  • Start date Start date
A

april

Column A Column B Column C
numbers =round(a1,0) =right(B1,1)

the numbers in Column C won't add. i keep getting -0-

thanks for your help
 
The RIGHT function returns text, which is ignored by the SUM function. Change
formula in column C to:

=MOD(B1,10)

to return the value of the one's digit.
 
perfect, both solutions solve the problem. thank you. also i didn't know
that @ right functions return text. --
aprilshowers
 
Back
Top