Hello,
I want to link between 2 if statement code.
I tried & but it didn't work, I'm getting both values 519 and 591 same as the figure below.
Solved! Go to Solution.
You are using or condition so for eg for value 9 both the condition will be true. because it's less than 11 and also less then 59. Also you are using & which is concat operator. You just need to start another if in the else block of the first if.
if(Value(DataCardValue447.Text)>=1 && Value(DataCardValue447.Text) <11,519,if(Value(DataCardValue447.Text)>=11 && Value(DataCardValue447.Text) <11,591))
Try:
If(
Value(DataCardValue447.Text) >= 1 || Value(DataCardValue447.Text) < 11, 519,
Value(DataCardValue447.Text) >= 11 || Value(DataCardValue447.Text) < 50, 591
)
It looks like you are trying to evaluate on intervals though. Should || be replaced by &&?
Hope that helps,
Bryan
Just change & to ,
If(logic 1, 519, If(locgic 2, 591))
You are using or condition so for eg for value 9 both the condition will be true. because it's less than 11 and also less then 59. Also you are using & which is concat operator. You just need to start another if in the else block of the first if.
if(Value(DataCardValue447.Text)>=1 && Value(DataCardValue447.Text) <11,519,if(Value(DataCardValue447.Text)>=11 && Value(DataCardValue447.Text) <11,591))
You are having greater than and less or equal to all referring to 11.
Can add some explanation on what you want to achieve?
------------
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.
User | Count |
---|---|
141 | |
97 | |
89 | |
78 | |
56 |
User | Count |
---|---|
190 | |
187 | |
105 | |
99 | |
91 |