Finding first cell from the left above threshold using Monte Carlo Simulation
Hi all,
I am using =MATCH(TRUE,INDEX(I105:AS105100000,0),0) to locate the first cell in a row that is above 100000. This works just fine in a regular spreadsheet. However, my spreadsheet uses a Monte Carlo simulation (Crystal Ball) and when letting it run I always receive an error for the cell with this function.
"A calculation error has occurred in cell [my cell]. You may wish to 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 cell in the row to always be above 100000. Still the error appears, so it's not likely that it would be triggered by a scenario w/o any number above 100000...
Any ideas?
|