Google-sheets – How to return a blank or dash when one of the cells is left blank

I just experienced the same issue and the problem seemed to be surrounding date formatting. The spreadsheet settings (file/spreadsheet settings) locale was set to United States and I'm in Canada. When I changed the locale to Canada, my sheet threw up the exact same error pattern as I saw in the final stage of the print process. I had to change a few cells that pulled date information (they were what were causing errors throughout the rest of the sheet) - specifically ones using the date() function. Once that was cleaned up, everything printed flawlessly.

I'd use this formula in E3 and copy down:

=IF(AND(E2<>"",OR(C3<>"",D3<>"")),E2-C3+D3,"")

EXPLANATION:
The IF statement contains 3 comma separated parameters:

1. logical_expression
2. value_if_true
3. value_if_false

In this case the logical expression is AND(E2<>"",OR(C3<>"",D3<>"")). AND takes multiple logical expressions as comma separated parameters, and returns TRUE only if all expressions are true. In this case these two:

1. E2<>""
2. OR(C3<>"",D3<>"")

Number one checks if there is anything in the cell above (if it's not equal to nothing). Number two is an OR function, works as AND but returns TRUE if only one or more of the expressions are true. In this case:

1. C3 (the Debit value on this row) is not empty
2. D3 (the Credit value on this row) is not empty

So to summarize If the cell above has a value, and Debit or Credit has a value. The value_if_true is used. In the example: E2-C3+D3 (the cell above minus Debit plus Credit).

If the expression evaluates to false, the value_if_false is used, in this case "" (an empty string).