Relative Content

Tag Archive for if-statementgoogle-sheetssumgoogle-sheets-formula

=if(sum(N3,P3),sum(N3,P3), “”) showing blank not zero

I am trying to make a gradebook in Google Sheets that tracks my Kindergarteners’ scores by standards. The following formula shows blank when there are zeros in the N3 and P3 columns. I want it to show zero if there is a zero but blank if the columns are blank.

=if(sum(N3,P3),sum(N3,P3), “”) showing blank not zero

I am trying to make a gradebook in Google Sheets that tracks my Kindergarteners’ scores by standards. The following formula shows blank when there are zeros in the N3 and P3 columns. I want it to show zero if there is a zero but blank if the columns are blank.

=if(sum(N3,P3),sum(N3,P3), “”) showing blank not zero

I am trying to make a gradebook in Google Sheets that tracks my Kindergarteners’ scores by standards. The following formula shows blank when there are zeros in the N3 and P3 columns. I want it to show zero if there is a zero but blank if the columns are blank.