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

------------------------------