Excel: Sum is more robust than the "+" operator

 Did you know?, in Excel the SUM function is more robust than simply writing the "+" operator,

Check cell E7, where the SUM function is used, and cell E6, where the "+" operator is used, both for two inputs: C6, which contains a number, and D6, which contains the character "a".

Example: Fórmulas.

Example: results.

As you can see, the "+" operator fails with an error message, but the SUM function returns the result based on the numeric input only.

This is something to have in mind when designing a spreadsheet!