Multiple IF statements

[PhilGlew]

Hi,

I have an IF statement working fine which is ...

If(Value(Label1.Text) <= 100, "100", Value(Label1.Text))

I now want to add to this so that if Label1's value is greater than or equal to 1000, it shows 1000, else it shows the value of Label1.Text

Thanks

Phil

[PG_WorXz10]

Hi @PhilGlew ,

Based on your requirement please check if below formula will work in your case or not ? 

If(Value(Label1.Text) <= 100,"100",(Value(Label1.Text)) >= 1000,"1000",Value(Label1.Text))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[PhilGlew]

Thanks, that's great.

One last thing. I have a button which, when the user clicks it, shows Label1 - what Visible properties do I need to input into Button1?

Thanks

Phil

[PG_WorXz10 · Accepted solution]

Hi @PhilGlew ,

If label1 will be visible on click of the button and you want to manage the visibility of the label than add below code.

Onselect Button : Set(varShowLabel,true)

On Label visibility : varShowLabel 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.