Merge 2 columns thar contain zéros

[Mederic]

Hello

I found this interesting tip which works with columns when the values contain null
In this example I would like to keep the zeros and the code doesn't work.
Is there a trick that doesn't require an if ?

Thanks in advance

Best regards

Debit	Credit
12	0
45	0
0	21
52	0
19	0
85	0

[Mederic]

Yes, it's a great way to learn and one that you'll never forget,
Thank you

[ronrsnfld · Accepted solution]

Just Add a Custom Column:

Name: Result

Formula: = [Debit] + [Credit]

[Mederic]

Hello @ronrsnfld 

I'm ashamed when I see the solution and I say to myself, why didn't I think of this  😀

Thank you

Best regards

[ronrsnfld]

I have done many "head slaps" over the years.