how do i add all digits in a cell with result being less than 10

[rufuxinix]

I need to add all digits in a cell and the result must be less thank 10
Example - 48 = 4+8 = 12 = 1+2 = 3

 

[Eric W]

Glad we could help!

 

[Rick Rothstein]

I also was a Math major in college, many years ago.

Me too! Also many years ago (think pre-calculators).

For those who might be interested, VB's Mod operator handles positive and negative numbers "correctly".

Function Modu(Number As Long, Modulus As Long) As Long
  Modu = 1 + (Number - 1) Mod Modulus
End Function

 

[Joe4]

Me too! Also many years ago (think pre-calculators).

I am a little younger than you. We actually did have calculators, though the fancy graphing calculators were just starting to come out.
I never owned a graphing calculator, but my friend did have one. We used it to play Hangman in Calc 3!

 

[Rick Rothstein]

I am a little younger than you. We actually did have calculators, though the fancy graphing calculators were just starting to come out.

I'll be about 1/3 of the way through my 70's in a little more than a month. I remember when I started work in 1970 at the place I retired (early) from after more than 32 years on the job, one of my co-workers was a Licensed Surveyor who practiced part-time on weekends. He bought one of (maybe thee) first handheld battery operated calculators. I think it was made by Sharp and I believe its name was ELSIE 8 (or something like that). I had 8 digits (with no guard digits as I recall), only the basic four functions (+-*/), an LED display that could not be read in the sunlight and... get this... no decimal point! It was a "true" replacement for a slide rule. He paid $400 (in 1970 money!) for it and was happy as could be over having purchased it.

 

[jtakw]

I'm also younger than you Rick, I had one of those Scientific Calculator wrist watches made by Casio when I was in College, used it everyday back then.

 

[Joe4]

I had 8 digits (with no guard digits as I recall), only the basic four functions (+-*/), an LED display that could not be read in the sunlight and... get this... no decimal point! It was a "true" replacement for a slide rule. He paid $400 (in 1970 money!) for it

It is amazing how far technology has come in such a short time (and it shows no sign of slowing down!).