Display Number only if 2 conditions are met

JeffG_WI

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

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

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!