Subtraction of two digits of more than 15 digits

[Hany ali]

hello every one
i want your Help ,how to Subtract Number from another and both of them it contains More than 15 Digits ,for Example
1100848020058807-1100848020058800 = 7

 

[Luke M]

XL only supports 15 digits of significance. As such, I don't think there's a way to 1)input the numbers you're wanting and 2) have it calculate the result. You're also going to struggle with accuracy, since XL (and most computers) have to store the numbers in binary.

https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft_Excel

 

[Hany ali]

thank you ,but i can't make it

 

[Hui]

To perform math on large numbers greater than 15 digits you will need to use some functions to assist

Have a read here and the comments and links associated

Large Number Arithmetic – Daily Dose of Excel

I have implemented those in your file

See attached and demonstrated Addition and Subtraction

 

[Hany ali]

thanks alot
Well done, always creative, generous professor -you have all my love and respect

 

[Hany ali]

But when I change the number 16 from right to any number it is converted to zero and I don't know why

 

[Hui]

I'm not sure what you mean as I can add numbers to them


Did you save it as a Macro enabled file and open it with Macro's Enabled

Also with numbers larger than 15v digits put a single ' at the front
eg: '1234567890123456789

 

[Hany ali]

thanks alot for Your Replay me, as you see in the photo ,i make the file as XLSM ,and i put elso asingle ' at the front
i want to see the result ,Not Correct

 

[deciog]

Decio

Hany there, good morning.

I did it this way so it helps in your problem, do several tests

Decio

 

[Hany ali]

Thank you very much and very sorry for your tiredness
And indeed at the hands of your presence and graciously you and you are credited with solving my problem
Thank you, Professor Generous with all my heart
and elso thanks alot for mr.Hui

 

[deciog]

This formula I think is better for your problem.

=VALUE(RIGHT(F6,15))-VALUE(RIGHT(F8,15))

Thanks for the feedback, I'm glad I helped

Hugs

Decio

 

[Hany ali]

thank You Very Much