I have a couple of questions regarding two formulas in one cell and getting #value when one of the formulas cells are empty.

The attached file shows the questions I have.

Thanks for the help!