How to hide formulas in a cell without locking the sheet

[apar93]

How can I hide the formulas in certain cells, still show the value, and not have to lock the sheet?

 

[Joe4]

If you want to hide them, you will either need to protect the sheet, as described here: https://www.techonthenet.com/excel/cells/hide_formulas2013.php
or use VBA (do all the calculations in VBA, or create User Defined Functions in VBA and use those).