I am writing a formula into google sheets and I do not want the formula to register a blank cell as zero. The formula is: =ARRAYFORMULA(MIN(IF(A:A=H12, (D:D-C:C))))It keeps giving me a zero value because some of the cells are blank. It is a monthly sales spreadsheet, so I don't have all of the data until the month is finished, but I'd like to have it working until I enter in all of the information.
Google Sheets registering blank cell as zero
google spreadsheets