The Calculation in Tools is set to automatic & the result of the formula is
shown during Function; however, the result of the formula will not show on
the worksheet, just the formula itself.