i wanted 2 And IF conditions on my data base. Can anyone show me how it can be achieved ?
Can you explain your IF conditions in more detail? That will help us tell you how to set it up.
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
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 ?
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
put is not… and else your action
Actually let me rethink that. What I said above won’t work.
OK, that makes more sense.
If Vendor is not Olive Then 0
If Status is not Completed Then 0
Else Amount to be Paid
Yes. Thank you so much. It worked !!! 