Welcome!

supprimer le 0 dans cellule

Bonjour à tous,

Je m' appel Sébastien et malheureusement je ne parle pas anglais.

J'ai un problème de formule dans une cellule. Je voudrais faire une addition et si la cellule de quantité est vide dans la cellule de destination je voudrais que le 0 ne soit plus afficher.

En vous remerciant.

Sébastien

Find more posts tagged with

Comments

Paul Newcome

The basic idea is to use an IF statement to say that if the result is not zero then output the result.

=IF([Column A]@row + [Column B]@row <> 0, [Column A]@row + [Column B]@row)

Adjust the column names and sum portion as needed. Depending on your region you may also need to swap the comma for a semi-colon.

sebi770

Hello Paul

Merci beaucoup pour ta formule.

Ca fonctionne nickel

Bonne soirée.

sebi770

Hello Paul,

Juste petite question, est-il possible de mettre le 0.00 si 1x0 = 0.00

Si cellule vide rien marquer.

Merci beaucoup.

Paul Newcome

Sure. Give this a try...

=IF(AND([Column A]@row <> "", [Column B]@row <> ""), [Column A]@row * [Column B]@row)

sebi770

Merci beaucoup.

La formule fonctionne nickel.

Toute bonne soirée.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Trending discussions

Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…