View the model
Download the model

What'sBest! does not support or recognize all of the hundreds of function available in Excel.							
Supported functions and operators are listed in the Supported Functions and Operations section of What'sBest! Documentation.							
If What'sBest! finds a cell containing an unsupported function, What'sBest! treats the cell as a constant fixed equal to its current computed value.							
							
This fixing by WhatsBest! is OK in two situations: 							
a) Any cell containing an unsupported function does not depend on an Adjustable cell, or 							
b) Any cell containing an unsupported function is used for reporting only, 							
    that is, no constraint cell or objective cell depends upon the cell.							
 If either of these conditions is violated, there may be two possible workarounds:							
     i) replace the unsupported functions by equivalent operations supported by What'sBest!, or 							
    ii) Split the cell containing an unsupported functions into two cells: 							
              one, say X1, that contains the unsupported functions but does not depend on any Adjustable cell, and a 							
              second cell, say X2, that does not contain any unsupported functions but may depend upon X1 and on Adjustable cells.