Google-sheets – Circular Dependency Error, Blank when 0

google sheets

I have tried both of these in Google Spreadsheets and continue to get circular dependency errors. I am trying to show blank when the result is 0. New values are entered daily and want to have the average formula run down the entire column so I don't have to drag the previous day's box down to copy the info.

=IF(C19="","",sum(C14:C18))

=IF(C19="0","",sum(C14:C18))

Best Answer

=average(C:C)

should average the whole of ColumnC's numeric values, without difficulties over text or spaces in that column, while responsive to changes in ColumnC entries - with the proviso that the formula should not be in ColumnC.

Related Solutions

Google Sheets Formulas – Fixing Circular Dependency with IFERROR

The pure spreadsheet answer is to create columns D and E to display your information. An example row:

A3: text
B3: (enter USD if known)
C3: (enter LBP if known)
D3: = if( isblank(B3) ; C3/1500 ; B3 )
E3: = if( isblank(C3) ; B3*1500 ; C3 )

The other way you can solve this is with JavaScript, if you know it, using the onEdit trigger. In that case the JavaScript would detect the edit to B3 and automatically add the formula in C3, or vice versa.

Google Sheets – How to Remove ‘0’ from a Field with an Equation

From the menu:

Format > Number > More Formats > Custom Number Format
Type in #,##0_);"("#,##0")";"-"_)

Best Answer

Related Solutions

Google Sheets Formulas – Fixing Circular Dependency with IFERROR

Google Sheets – How to Remove ‘0’ from a Field with an Equation

Related Topic