Limit to MOD function
I have discovered that the MOD funcktion apparently does not work for numbers larger than 268,435,455, as larger numbers return #NUM!. I do not seem to be able to find any documentation for this.
Can anybody help? Is there such a limitation, and is it documentet? Jan |
Limit to MOD function
|
Limit to MOD function
Thank you. I used the workaround and I also found an explanation: http://excel.tips.net/T003302_Large_..._Function.html Jan |
All times are GMT +1. The time now is 03:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com