Home

Help with an Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-834131%22%20slang%3D%22en-US%22%3EHelp%20with%20an%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834131%22%20slang%3D%22en-US%22%3EI'm%20not%20sure%20if%20what%20I%20need%20is%20possible.%3CBR%20%2F%3EWhen%20I%20add%20the%20value%20of%20two%20cells%20(ie%20a1%20%3D%203%20%26amp%3B%20a2%20%3D9%20giving%20a%20total%20of%2012)%20I%20want%20to%20be%20able%20to%20take%20the%20second%20digit%2C%20(in%20this%20example%20it%20would%20be%20the%20'2')%20and%20display%20it%20in%20another%20cell.%20I%20tried%20just%20subtracting%2010%20from%20the%20total%20but%20then%20this%20wouldn't%20work%20correctly%20if%20the%20total%20was%2020%20or%20greater.%3CBR%20%2F%3EIs%20there%20any%20way%20this%20can%20be%20achieved%3F%3CBR%20%2F%3EThanks%20in%20advance%20for%20any%20help!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-834131%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834560%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20an%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834560%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402442%22%20target%3D%22_blank%22%3E%40CSlane29%3C%2FA%3E%26nbsp%3BAlthough%20this%20community%20is%20for%20Ms%20Access%20your%20question%20has%20a%20very%20easy%20answer%3C%2FP%3E%3CP%3EAssuming%20you%20perform%20this%20addition%20in%20C1%20cell%20then%20to%20get%20%222%22%20...eg.%20in%20Cell%20D1%20it%20would%20be%20%3A%3C%2FP%3E%3CP%3E%3DMID(C1%3B2%3B1)%3C%2FP%3E%3C%2FLINGO-BODY%3E
CSlane29
Regular Visitor
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!
1 Reply

@CSlane29 Although this community is for Ms Access your question has a very easy answer

Assuming you perform this addition in C1 cell then to get "2" ...eg. in Cell D1 it would be :

=MID(C1;2;1)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies