F
faitdumal
Hi all,
I am using =MATCH(TRUE,INDEX(I105:AS105>100000,0),0) to locate the firs
cell in a row that is above 100000. This works just fine in a regula
spreadsheet. However, my spreadsheet uses a Monte Carlo simulatio
(Crystal Ball) and when letting it run I always receive an error for th
cell with this function.
"A calculation error has occurred in cell [my cell]. You may wish t
check your formulas and assumptions for division by 0, etc."
I am not sure what the reason could be - I even hard-coded the last cel
in the row to always be above 100000. Still the error appears, so it'
not likely that it would be triggered by a scenario w/o any number abov
100000...
Any ideas
I am using =MATCH(TRUE,INDEX(I105:AS105>100000,0),0) to locate the firs
cell in a row that is above 100000. This works just fine in a regula
spreadsheet. However, my spreadsheet uses a Monte Carlo simulatio
(Crystal Ball) and when letting it run I always receive an error for th
cell with this function.
"A calculation error has occurred in cell [my cell]. You may wish t
check your formulas and assumptions for division by 0, etc."
I am not sure what the reason could be - I even hard-coded the last cel
in the row to always be above 100000. Still the error appears, so it'
not likely that it would be triggered by a scenario w/o any number abov
100000...
Any ideas