Calculations

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
323
Office Version
  1. 365
Platform
  1. Windows
Hello All,

My computer is Asus and Operating system is Windows 10.

Could I please get help with a formula?

I need a formula that adds and subtracts numbers (without negative) and only displaying the second digit (if a two-digit number).

Note: “0” is “10”
mr excel.jpg



Also, I was told by another awesome member that it would be helpful to post using XL2BB addin. Tried as I might, I couldn’t get it to work for me (I’m not the most tech savvy person so I apologize for the inconvenience).

Thank you so much for your help in advance.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Well...
In C2 you can use:
=RIGHT(A2+B2,1)
...then copy down.

...and in G2:
=RIGHT(E2-F2,1)

BUT in order to get G5's result as per you example, I had to put the proper "10" in E5. I know you made a point about this, but not sure how your cells are formatted.

Is this even close to what you need?
 
Upvote 0
(same as jasonb75's formula in column C)

20 08 01.xlsm
ABCDEFG
1
2730734
3976972
4628624
5066064
6426422
MrsFrankieH
Cell Formulas
RangeFormula
C2:C6C2=MOD(A2+B2,10)
G2:G6G2=MOD(10+E2-F2,10)
 
Upvote 0
Well...
In C2 you can use:
=RIGHT(A2+B2,1)
...then copy down.

...and in G2:
=RIGHT(E2-F2,1)

BUT in order to get G5's result as per you example, I had to put the proper "10" in E5. I know you made a point about this, but not sure how your cells are formatted.

Is this even close to what you need?


Hello Sykes!! Thank you so much!! I'll give it a try and keep you posted!!
 
Upvote 0
(same as jasonb75's formula in column C)
(same as jasonb75's formula in column C)


YAY!!! Thank you Peter!! You always come to my rescue!!! Thank you so much!!!! :)

20 08 01.xlsm
ABCDEFG
1
2730734
3976972
4628624
5066064
6426422
MrsFrankieH
Cell Formulas
RangeFormula
C2:C6C2=MOD(A2+B2,10)
G2:G6G2=MOD(10+E2-F2,10)


20 08 01.xlsm
ABCDEFG
1
2730734
3976972
4628624
5066064
6426422
MrsFrankieH
Cell Formulas
RangeFormula
C2:C6C2=MOD(A2+B2,10)
G2:G6G2=MOD(10+E2-F2,10)
 
Upvote 0
Well...
In C2 you can use:
=RIGHT(A2+B2,1)
...then copy down.

...and in G2:
=RIGHT(E2-F2,1)

BUT in order to get G5's result as per you example, I had to put the proper "10" in E5. I know you made a point about this, but not sure how your cells are formatted.

Is this even close to what you need?


Thank you Sykes!!! Your formula worked as well!!!
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top