Forum Discussion

Rafael Donado's avatar
Rafael Donado
Copper Contributor
Sep 04, 2017
Solved

Excel: Value "cero" vs Empty Cell

Hi every one (sorry for my english, not native). I'm working on a table in which i need to see the minimum value of a column. I have no problem when there are values in some of the cells, the progra...
  • Detlef_Lewin's avatar
    Sep 04, 2017

    Rafael,

     

    one way:

    =IF(COUNT(A1:A10),MIN(A1:A10),"")

Resources