Forum Discussion
Solved
How to change max number of VBA function
Hello I wrote a custom function in excel, but when I use large numbers (250,000) it comes back as #=NUM! Only relevant info I found seems to be here: https://support.microsoft.com/en-u...
The range of Integer is -32768 to +32767.
Use Double or Currency for BaseCost, and Long for NumOwned.
Okay interesting, thanks so Integer, double, long etc.. in excel is not even close to what it is in other programming languages ?? for example in C# an int is = 2,147,483,647
That is correct. See Data type summary