How to use And/Or

[sienna28]

How can I perform an And/or check behind a button

This one works fine

If(Value(Blood1.Text) >= 120 && Value(Blood1.Text) <=129  && Value(Blood2.Text) < 80 ,Set(colorset,"#ffff1a");Set(txtval,"ELEVATED"));

But what if I want to check two text box values using an and/or calculation?

If textbox1 > 80 and/Or  textbox2 > 120

Thanks

[eka24]

If(Value(Blood1.Text) >= 120 Or Value(Textbox2.Text) > 120&& Value(Blood1.Text) <=129  && Value(Blood2.Text) < 80 Or Value(Textbox1.Text) > 80,Set(colorset,"#ffff1a");Set(txtval,"ELEVATED"));

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[mdevaney]

@sienna28 
Can you please clarify what you want to do with this code?  I don't understand having both the AND and the OR.

If textbox1 > 80 and/Or  textbox2 > 120

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[sienna28]

Thanks for the reply.

It just needs to work for these values

If textbox1 > 80 and/Or  textbox2 > 120

[mdevaney]

@sienna28
I guess what i am asking here is do you want the condition to be AND or OR for your code above: it cannot be both.

[sienna28]

Please see attached for explanation.

If you notice the second value is where the And/Or is done

[Drrickryp]

Hi @sienna28 

In your example, the And is irrelevant.  If either value is outside of the range, the result will be flagged. I would just go with the Or condition.

[mdevaney]

@sienna28 

Based on your image I would set your conditions like this.

If(
    Value(Blood1.Text) >= 180 Or Value(Blood2.Text) >= 120,
    Set(colorset,"#ffff1a"),
    Set(txtval,"ELEVATED")
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[sienna28]

Hi

That looks like it could be it, but I am not sure how it reads.

Could you please explain that logic to me....does the 180 value come into it?

Many thanks

[sienna28]

I've attached a better graphic which shows what I am trying to do.

Using the Or condition only in the last option triggers the one above it.