#DIV/0! error when data is blank

[hertzya]

Im trying to build a spreadsheet on data obtained from patients. I would like to express as a percentage of data captured.  I have already set the constants to numbers only, but when I clear a cell (because there is no data yet), my percentage cell gives a #DIV/0! error. My formula is =SUM(C5,D5,F5)/B5. Additionally, B5's formula is =SUM(C5:F5). Thanks for any help.

[#2 · Accepted solution]

@hertzya 

=IFERROR(SUM(C5,D5,F5)/B5,"")

You can wrap the formula in IFERROR.

[#3]

That did it. Thank you.