Forum Discussion
Rafael Donado
Sep 04, 2017Copper Contributor
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.
Rafael,
one way:
=IF(COUNT(A1:A10),MIN(A1:A10),"")
- Detlef_LewinSilver Contributor
Rafael,
one way:
=IF(COUNT(A1:A10),MIN(A1:A10),"")
- Rafael DonadoCopper Contributor
Thanks! this was exactly what i was looking, clever solution.