Use of Formula Forge is governed by Microsoft's Office Store Standard Application License Terms. In particular,
Formula Forge is licensed "As-is," "With all faults," and "As available," without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose, and non-infringement. You bear all risks of using it. In no event shall Stage One Software be liable for any claim, damages or other liability, whether in an action of contract, tort or otherwise, arising from, out of, or in connection with Formula Forge.
Use with caution
Formula Forge makes temporary changes in a spreadsheet in order to display values for elements in its tree view. To ensure accuracy, it writes elements in a formula into the cell from which it came, and it gets their values from Excel. When it has finished computing values in this fashion, it restores the original contents of the cell.
This process can change the value of a formula that contains a volatile
function. Such a function generally produces a different result when it is re-evaluated. For
RND deliberately produces different (and unpredictable) values.
RNDBETWEEN are also volatile, as are
SUMIF for certain arguments.
Excel recommends using volatile functions sparingly.
Use Formula Forge with particular caution with the online version of Excel,
which stores spreadsheets on OneDrive and automatically saves all changes. As a
result, the temporary changes Formula Forge makes in a spreadsheet
will be visible temporarily on OneDrive. Likewise, use Formula Forge with caution
with desktop versions of Excel when
AutoSave is on.