Help displaying a value present in another column if both conditions are met.

brad.harder

I've been trying to create a formula that will display the Remaining fifty percent when I meet two conditions. Set up to be billed has to be 50% and Live Date can't be blank. If both are true, then display the Amount due for Integration. I have tried to use If and If Contains to no avail.

Paul McGuinness

Hi @brad.harder

This formula should do what you need,

=IF(AND(ISDATE([Live date]@row), [Set up to be billed]@row = 0.5), [amount due for integration fee]@row / 2, "")

Tested as below.

Hope it helps

Thanks

Paul

Paul McGuinness

Hi @brad.harder

This formula should do what you need,

=IF(AND(ISDATE([Live date]@row), [Set up to be billed]@row = 0.5), [amount due for integration fee]@row / 2, "")

Tested as below.

Hope it helps

Thanks

Paul

brad.harder

It worked, thank you!

I modified the last part and removed the divide by 2. I essentially just needed it to display the the amount due for intergration fee again. For context, they need to pay 50% initial (integration) and the remainder once live.

=IF(AND(ISDATE([Live Date]@row), [Set up to be billed]@row = 0.5), [Amount due for Integration Fee]@row, "")