Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit to MOD function
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit on logical function | Excel Discussion (Misc queries) | |||
Limit a cell to except a function only. | Excel Worksheet Functions | |||
len limit of 255 of function. any workaround? | Excel Programming | |||
IF limit reached... what function would be better? | Excel Worksheet Functions | |||
IF Function Help due to 7 limit | Excel Worksheet Functions |