if statement with ||

[altanzaya]

Dear Pros,

I am trying to use If, but it is not working properly as I want.

When in TEXT INPUT input some currency then LABEL should show the right behind numbers which shown in table below.

0-500,000	1
500,001-1,000,000	2
1,000,001-5,000,000	3
5,000,001-10,000,000	4
10,000,001- more	5

I try : 

If(Value(Scoring.Text) <= 500000 ,1, Value(Scoring.Text) >= 10000001,5,Value(Scoring.Text) > 500000 || Value(Scoring.Text)<= 1000000,2, Value(Scoring.Text) > 1000000 || Value(Scoring.Text) <= 5000000,3,4)

This is not working as I want, please check the codes and help me to fix.

BR

Altanzaya

[WarrenBelz · Accepted solution]

Hi @altanzaya ,

Try this

Switch(
   Value(Scoring.Text),
    <= 500000,1, 
   (> 500000 && <= 1000000),2,
   (>1000000 && <= 5000000),3,
   (>5000000 && <= 10000000),4,
   5
)

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.

[Drrickryp]

Hi @altanzaya 

The Switch function works better here I think,

Switch(Value(Scoring.Text), <=50000,"1",> 500000 && <= 1000000,"2", >100000 && <=5000000,"3","4")

[altanzaya]

Dear Drrickryp Super User,

Please check the error

BR
Altanzaya

[WarrenBelz]

Sorry @altanzaya ,

Logical error in mine (now fixed) - I was focusing on syntax instead of mathematical logic)

[altanzaya]

Dear WarrenBelz

It appears same error 😞

[WarrenBelz · Accepted solution]

Sorry @altanzaya ,

I really thought that would work - I should have tested it - this does

With(
    {vScore: Value(Scoring.Text)},
    If(
        vScore <= 500000,
        1,
        vScore > 500000 && vScore <= 1000000,
        2,
        vScore > 1000000 && vScore <= 5000000,
        3,
        vScore > 5000000 && vScore <= 10000000,
        4,
        5
    )
)

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.

[altanzaya]

Yesssss it is working thank u very much!!!!