Display Number only if 2 conditions are met

Good morning,

I am trying to display the lowest bid in a column only if the [BID AMOUNT] cell is not blank AND if the checkbox under [UNVETTED] is NOT checked.

For the first half, I have this:

=IFERROR(SMALL([BID AMOUNT]40:[BID AMOUNT]44, COUNTIF([BID AMOUNT]40:[BID AMOUNT]44, 0) + 1), "")

Which works exactly as I want. But adding the second condition where the box in the [UNVETTED] column is unchecked.

Thanks in advance for your help!

Jeff

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @JeffG_WI

Try adding a COLLECT Function to your formula to identify the second criteria, like so:

=IFERROR(SMALL(COLLECT([BID AMOUNT]40:[BID AMOUNT]44, UNVETTED40:UNVETTED44, 0), COUNTIFS([BID AMOUNT]40:[BID AMOUNT]44, 0, UNVETTED40:UNVETTED44, 0) + 1), "")

Let me know if that works for you!

Cheers,

Genevieve

All comments

Genevieve P.

Hi @JeffG_WI

Try adding a COLLECT Function to your formula to identify the second criteria, like so:

=IFERROR(SMALL(COLLECT([BID AMOUNT]40:[BID AMOUNT]44, UNVETTED40:UNVETTED44, 0), COUNTIFS([BID AMOUNT]40:[BID AMOUNT]44, 0, UNVETTED40:UNVETTED44, 0) + 1), "")

Let me know if that works for you!

Cheers,

Genevieve

JeffG_WI

Hi Genevieve,

Works like a charm!

Thanks!

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.