• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Subtraction of two digits of more than 15 digits

Hany ali

Active Member
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
 

Attachments

  • Example.xlsx
    9 KB · Views: 8
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

I have implemented those in your file

See attached and demonstrated Addition and Subtraction

63515
 

Attachments

  • Copy of Example.xlsm
    16.9 KB · Views: 15
Last edited:
thanks alot
Well done, always creative, generous professor -you have all my love and respect
 
Last edited:
I'm not sure what you mean as I can add numbers to them
63531

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
 
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
 

Attachments

  • Untitled.png
    Untitled.png
    113.5 KB · Views: 12
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
 
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
 

Attachments

  • Example Decio 2.xlsx
    10 KB · Views: 9
Back
Top