In the case of DIVIDE by ZERO, I want cell to show "" nothing or hyphen.

I'm getting percentage for referrals that result in new business. For forward months (Aug-Dec) there are no referrals yet so the formula is dividing by 0. How can I adjust the formula to return nothing or a dash for those months?

This is the formula that returns the right numbers if there are successful referrals in a given month:

=IF(COUNTIFS({Status}, CONTAINS("Converted", @cell ), {Referral Date}, >=DATE(2025, 7, 1), {Referral Date}, <=DATE(2025, 7, 31)), >0) / [Column8]3

Where [Column 8]3 is total referrals. If it is zero, I want the cell to be blank or show a dash. Thanks, Lisa

Find more posts tagged with

Accepted answers

All comments

jmyzk_cloudsmart_jp

@lisalettieri

=IF([Column8]3 = 0, "", COUNTIFS({Status}, CONTAINS("Converted", @cell ), {Referral Date}, >=DATE(2025, 7, 1), {Referral Date}, <=DATE(2025, 7, 31)) / [Column8]3)

=IF([Column8]3 = 0, "-", COUNTIFS({Status}, CONTAINS("Converted", @cell ), {Referral Date}, >=DATE(2025, 7, 1), {Referral Date}, <=DATE(2025, 7, 31)) / [Column8]3)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.