Fortunately, the IFERROR function will embed "0" in those cells, which fixes the issue: =IFERROR (TrustFlow/CitationFlow*100,0) Also, multiplying the ratio by 100 and rounding it up will make it ...