I am trying to reference a multi-select drop down in an IF formula.
I am create a formula where when two certain items from a mutli-select dropdown are selected, the formula will return 12.5, All other options or combination of options return 0.
I cannot get the reference right for having two options selected.
Answers
-
Try something like this:
=IF(AND(COUNTM([Column Name]@row) = 2, HAS([Column Name]@row, "The client has entered sales receipts instead of invoices."), HAS([Column Name]@row, [The client has marked the invoices paid in full.")), 12.5, 0)
-
@Paul Newcome Thank you. This was closer than I had gotten, however, it is still erroring for me.
When I use this formula, I get #UNPARSEABLE. `
When I use the second screen shot, I get #INCORRECT ARGUMENT SET.
Any ideas where I am mis-stepping?
Thank you!
-
Your first formula is correct, however you have too many parentheses added in.
See how after the AND( you have AND(( < you only need one ( after AND, not two.
Remove the pink one... then you'll need to also remove the pink closing ) before the , 12.5:
so there's only two here > )), 12.5, 0)
Cheers,
Genevieve
-
@Genevieve P. & @Paul Newcome Thank you both! Together you helped me resolve this issue.
Help Article Resources
Categories
Check out the Formula Handbook template!