Is it possible to show zero for negative numbers

[kiwicolin]

Hi all.

I have a spreadsheet where multiple columns are added together. In the final total column I would like all negative numbers to appear as zero. I would like to retain the actual figure but just to display zero, while all positive numbers I would like to display as normal.

Is this possible to do?

Thank you.

[BenjieLop]

Hi all.

I have a spreadsheet where multiple columns are added together. In the final total column I would like all negative numbers to appear as zero. I would like to retain the actual figure but just to display zero, while all positive numbers I would like to display as normal.

Is this possible to do?

Thank you.

Will this help?

=if(your_formula<0,0,your_formula)

[kiwicolin]

Excellent

Thanks for your help.

[BenjieLop]

Excellent

Thanks for your help.

You're welcome ... thanks for the feedback.