Products

Customers

Resources

Products

Customers

Resources

The QuickBooks two-way sync you’ve been waiting for launches Dec 9th at 2 PM ET. Register before it’s too late.

The QuickBooks two-way sync you’ve been waiting for launches Dec 9th at 2 PM ET. Register for the webinar before it’s too late.

Google Sheets Formulas

How to remove empty 0's from your Google Sheet

SHARE THIS Article

We may sometimes have rows in your financial report that contains 0's.

Those can be annoying. Here's a simple formula to replace them with two dashes (--).

  1. Instead of writing SUM(A1:B1)

  2. Write IF(SUM(A1+B1)=0,"--",A1+B1)

The formula simply checks if the sum of A1+B1 equals 0, and if it does, it prints "--". If it's not zero, it prints the actual value.

‍

Supercharge your financial reporting

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorized payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorized payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorized payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.

LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorized payment institution regulated by the Financial Conduct Authority under the Payment Services Regulations 2017. Plaid provides you with regulated account information services through LiveFlow as its agent.

© LiveFlow. All rights reserved.

Flow native Ramp integration.