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 program selects the minimum only on the cells with value. But when the table is empty, the minimum shows "0". In this case, i need to see a cero only if the minimum is cero, but if the table is empty i need it to show nothing. What can i do?

Thanks in advance.

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Rafael,

     

    one way:

    =IF(COUNT(A1:A10),MIN(A1:A10),"")
    • Rafael Donado's avatar
      Rafael Donado
      Copper Contributor

      Thanks! this was exactly what i was looking, clever solution.

Resources