Forum Discussion
Formula Cell Formating
I have a spread sheet cell with the following example formula, [=sum(X4/X15]. Since there is no data entered in either X4 or X15, the cell looks like this "####". How can I change the cell appearance...
Thanks for your response. I am doing an Excel worksheet for basketball stats. I have attached the file that I am trying to remove the "####".
Hi Michael,
If you increase your columns width you'll see what cells with #### actually contains division on zero errors (#DIV/0!). To avoid instead of your formula
=SUM(O4/P4)
you may check first if you divide on zero or not like
=IF(P4,O4/P4,0)
or, as Willy suggested, if any error appears to return zero instead
=IFERROR(O4/P4,0)
I appreicate your response. I used Willy's suggestion and it cleaned up the cells. Thanks for your assistance.