If cells are showing formula instead of the result, try following steps:
- Check that the cell is formatted as General or other appropriate number type.
- Verify cell is actually calculating properly.
- Put value in another cell and link to the cell containing the formula.
- Double-check cell references in the formula.
- Check that automatic calculation is on.