How can I show the value zero where the formula doesn’t give a valid result? Use IFERROR: =IFERROR(E7+E8;0) Result:
