Calculations

[MrsFrankieH]

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”

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.

 

[MrsFrankieH]

for column G try

=ABS(SUBSTITUTE(E2,0,10)-SUBSTITUTE(F2,0,10))

Thanks Peter!! Trying it now.

 

[MrsFrankieH]

Thanks Peter!! Trying it now.

It worked!!! Thank you Peter!!! Have a great day!!!

 

[Peter_SSs]

Cheers