Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 06 Apr 2017 17:16:10 +0200How to make LibreOffice Calc treat empty cells as zeros when using ranges in formulas?https://ask.libreoffice.org/en/question/92199/how-to-make-libreoffice-calc-treat-empty-cells-as-zeros-when-using-ranges-in-formulas/I need to take the minimum over a range of cells, treating empty cells as zeros. However, both `MIN` and `MINA` functions ignore empty cells (in LibO 5.1). What can I do?
More precisely, what I currently need is to calculate the minimum of each line in a table treating empty cells as `0` and to store the results in the last column.alexeymuranovThu, 06 Apr 2017 17:16:10 +0200https://ask.libreoffice.org/en/question/92199/