=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.