Removing Zero from my results

Can anyone see what is wrong with this equation. Trying to remove zero from my column when nothing has been done.

=IF({08 - Estimating # of Pricing} = 0, INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)), "")

Find more posts tagged with

Accepted answers

KPH

Hi @Robert S Fike

It sounds like you are trying to return the value from 08 - Estimating # of Pricing in a different sheet where the Job # matches, but if this is 0 you want to return blank? Is that correct?

If so, I believe you need to have the IF evaluate the result of the INDEX MATCH rather than the column as it won't know which cell in the column to look at. Try this:

=IF(INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)) = 0, "", INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)))

All comments

KPH

Hi @Robert S Fike

It sounds like you are trying to return the value from 08 - Estimating # of Pricing in a different sheet where the Job # matches, but if this is 0 you want to return blank? Is that correct?

If so, I believe you need to have the IF evaluate the result of the INDEX MATCH rather than the column as it won't know which cell in the column to look at. Try this:

=IF(INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)) = 0, "", INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)))

Robert S Fike

TYVM

KPH

NP, HTH

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.