Forum Discussion
Help with an Excel formula
I'm not sure if what I need is possible.
When I add the value of two cells (ie a1 = 3 & a2 =9 giving a total of 12) I want to be able to take the second digit, (in this example it would be the '2') and display it in another cell. I tried just subtracting 10 from the total but then this wouldn't work correctly if the total was 20 or greater.
Is there any way this can be achieved?
Thanks in advance for any help!
When I add the value of two cells (ie a1 = 3 & a2 =9 giving a total of 12) I want to be able to take the second digit, (in this example it would be the '2') and display it in another cell. I tried just subtracting 10 from the total but then this wouldn't work correctly if the total was 20 or greater.
Is there any way this can be achieved?
Thanks in advance for any help!
