numbers derived from @ right function don't add
 

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
--
aprilshowers

numbers derived from @ right function don't add
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"april" wrote:

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
--
aprilshowers

numbers derived from @ right function don't add
 

Try changing formula in C1 to:

=right(B1,1)+0

this converts text string to number.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126344

numbers derived from @ right function don't add
 

perfect, both solutions solve the problem. thank you. also i didn't know
that @ right functions return text. --
aprilshowers


"april" wrote:

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
--
aprilshowers