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 to at least have it have a Zero in the cell, Thanks,
4 Replies
- Did you try =IFERROR(X4/X15,0)?
I think that you do not need to use SUM function.
"The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges or a mix of all three." from https://support.office.com/en-us/article/SUM-function-043e1c7d-7726-4e80-8f32-07b23e057f89Thanks 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)
