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...
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-07b23e057f89
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-07b23e057f89
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.
