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 (--).
Instead of writing SUM(A1:B1)
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
Recent
LiveFlow is an agent of Plaid Financial Ltd. (Company Number: 11103959, Firm Reference Number: 804718), an authorised 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 authorised 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 authorised 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 authorised 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.