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.
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 256
تاريخ: دوشنبه
28 تير
1395 ساعت: 6:58