Forum Discussion

hertzya's avatar
hertzya
Copper Contributor
Nov 05, 2022
Solved

#DIV/0! error when data is blank

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 (...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 05, 2022

    hertzya 

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

    You can wrap the formula in IFERROR.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 05, 2022

hertzya 

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

You can wrap the formula in IFERROR.

 

  • hertzya's avatar
    hertzya
    Copper Contributor
    Nov 05, 2022
    That did it. Thank you.

Resources