Exponentiate very large numbers

[Matura]

Hello to all the experts,

Is there a way to exponentiate numbers (both positive, negative, even rational) in Excel, even with significantly more than 20 decimal places, and this
also with both positive, negative (also rational) exponents? I think this can then also be used for reversal operations (roots).

An example would be

4.055,546363737^3.5

or even

5.656.747,543635737373^-0.2803

Presumably there would also be approaches in VBA, but I'm not an Excel or VBA expert, hence my question.

I've already had help with add-ins that handle very large numbers in basic arithmetic, but exponentization is still missing.

Thank you very much.

[MrShorty]

Not with Excel's native tools. Excel natively uses double precision for its calculations and storage, and those kinds of numbers would go well beyond the limits of double precision.

I occasionally come across tools that claim to do arbitrary precision arithmetic in Excel. I have never tried them. Some of them require buying a license. If you can find a library of arbitrary precision procedures (whether for Excel or for another programming language), that would probably be easiest.

A couple of past conversations here involving arbitrary precision arithmetic: https://www.excelforum.com/excel-for...ml#post4947996
https://www.excelforum.com/excel-pro...ith-excel.html

[Matura]

Thank you.

Yes, of course not common Excel, as it does not work. So I thought VBA could be a way.

[MrShorty]

Did you follow the links I gave? One of them has VBA procedures for doing "large addition" and "large multiplication" that might be the kind of thing you are looking for. I have no real experience with programming arbitrary precision arithmetic, so I can't help with the details, but I'm confident that someone with the right knowledge about arbitrary precision algorithms could program something in VBA. Even if you are not an expert in Excel and/or VBA, do you have experience with arbitrary precision algorithms in other programming languages?

[Matura]

No. I have not.

And I have different Add-Ins for basic calculation operations, but not for exponentiation.

[Matura]

MrShorty

I found some interesting sources within the deeps of the internet. Thanks for giving me some hints!

[Muhammad Fraz]

Hello Mate Matura,

From past year, I am working on researching on different properties on numbers. The issue you are facing is currently same applies to me. Basically my research is for Recreational Mathematics. There are lots of websites that can do this task what you have ! But of course they need to purchase a plan for your specific needs. Currently I am doing my research on my own but as Excel is limited to do that task with Big Numbers like exponentiation (even I have not any add-ins for basic operations). Please provide some basic info what type of Add-ins you have if you are interested ? But for your task definitely Excel is not the choice even online websites don't offer that free because it requires extra bandwidth.

[Muhammad Fraz]

PS: The Limit of the number on any online website is currently can be upto 10 Billion and its exponent is 10 Thousands only as far as I know that applies only for bandwidth, not for the actual algorithm thay have.