Is there a formula that adds, subtracts, multiplies, and or divides two digit numbers in a single cell?

[MrsFrankieH]

Are there formulas that will add, subtract, multiply, and/or divide data from two-digit numbers in a single cell?

I appreciate any help I can get. Thank you in advance.

 

[MrsFrankieH]

Hello Peter!!

I hope you had a great Sunday!!
Here is the screenshot of the 'error' message I get as well as data and expected result.
Thanks again!!

 

[Peter_SSs]

Here is the screenshot of the 'error' message I get as well as data and expected result.

I can't see any error message but these seem to give the results that you have shown.

Please check the result if the number is 10 to see if it is what you expect.

BTW: You will get many more potential helpers if you post any sample data in a format that can be copied for testing, unlike the images you have been posting. My signature block below has help regarding that.

Excel Workbook
	E	F	G	H	I	J
1		4	5	20	25	29
2
3	Addition	4	5	2	7	1
4	Subtraction	6	5	8	3	7
5	Multiplication				0	8
6	Division			5
7
8
9		1	2	4	35	42
10
11	Addition	1	2	4	8	6
12	Subtraction	9	8	6	2	2
13	Multiplication				5	8
14	Division					2
Post 21

 

[MrsFrankieH]

Thank you so much Peter!! I'm going to try it out now. I can't thank you enough for your patience.

 

[MrsFrankieH]

Hello Peter!!

Addition and subtraction works like a charm but I'm having some errors with multiplication and division. Not to worry. I don't need those two at the moment.
In the future if I need help, I won't use a jpg, I'll post sample data as you requested.
Thanks again for you patience and hard work.

 

[Peter_SSs]

Addition and subtraction works like a charm ..

Good news!

.. but I'm having some errors with multiplication and division.

Care to give some examples where the errors arise together with what the expected results are and why?