Implement 2 If conditions

[Jenish_Shrestha]

i wanted 2 And IF conditions on my data base. Can anyone show me how it can be achieved ?

[Jeff_Hager]

Can you explain your IF conditions in more detail? That will help us tell you how to set it up.

[Uzo]

you can add as many conditions as you want in the IF-ELSE column… just think about how to place them in order, to achieve desired effect

[Jenish_Shrestha]

Here I want “Amount to be paid” displayed only when both of those conditions are met.
2 If conditions should be true to display the result. Did it make it clear ?

[Jeff_Hager]

I would do it like this:

If Vendor is not Olive Then 0
If Vendor is not Completed Then 0
Else Amount to be Paid

[Uzo]

put is not… and else your action

[Jeff_Hager]

Actually let me rethink that. What I said above won’t work.

[Jenish_Shrestha]

oh no the 2 conditions were supposed to be this. my bad

[Jeff_Hager]

OK, that makes more sense.

If Vendor is not Olive Then 0
If Status is not Completed Then 0
Else Amount to be Paid

[Jenish_Shrestha]

Yes. Thank you so much. It worked !!!