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
Best Answer
-
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
Answers
-
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
-
Hi Genevieve,
Works like a charm!
Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!