GregVasilion
4 years agoQrew Member
Function firing when BOTH conditions are true?
Hello!
I have been trying to find an answer on these boards but can't seem to pin down the right search terms. I have a function that I would like to fire only when multiple conditions are both met. This is for calculating a price per unit where my conditions are [Supplier]="Supplier A" and [Premium unit]=TRUE.
My current formula is
If(
[Premium unit]=true,
[Unit count]*20)
This only tackles half of the issue, as the price (20) changes per supplier. I cannot figure out how to add the second condition of the supplier being equal to supplier A. The [Premium unit] field is a checkbox and the [Supplier] field is a multiple choice dropdown. As a bonus question, could I in the same formula change the values for Supplier B?
Thanks for any help!
------------------------------
Greg Vasilion
------------------------------