Google Sheet Null - Using the find and replace feature. When your data range contains numerical data. When your data range contains text data. Web in this tutorial we will show you 3 ways to fill empty cells with 0 in google sheets: For the latter two methods, there can be further two cases: Web to allow for the possibility that the maximum value is indeed 0 (rather than that there is no value): =arrayformula(if(iserror(match(b285,'2014 donations log'!f:f,0)),,max(if(b285='2014 donations log'!f:f,'2014 donations log'!a:a)))) answered feb 14, 2015 at 3:49.
For the latter two methods, there can be further two cases: When your data range contains text data. When your data range contains numerical data. =arrayformula(if(iserror(match(b285,'2014 donations log'!f:f,0)),,max(if(b285='2014 donations log'!f:f,'2014 donations log'!a:a)))) answered feb 14, 2015 at 3:49. Web in this tutorial we will show you 3 ways to fill empty cells with 0 in google sheets: Web to allow for the possibility that the maximum value is indeed 0 (rather than that there is no value): Using the find and replace feature.