Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

#DIV/0! error when data is blank

Copper Contributor

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 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@hertzya 

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

You can wrap the formula in IFERROR.

iferror.JPG

 

That did it. Thank you.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@hertzya 

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

You can wrap the formula in IFERROR.

iferror.JPG

 

View solution in original post