Post

1 follower Follow
0
Avatar

Multiple if statements

I need to do a multiple if string, here is what I am trying to do,

 

If $C_CurrencyX is 0, then 0

between 1 & 100, then 1,

between 100 to 500, then 2,

between 500 to 1000, then 3,

between 1000 to 2000 then 4

above 2000 then 5

 

 $C_CurrencyX is currency type, 1,2,3,4,5 numeric, so I was using currency(1) etc

 

Can someone help with this?

Biju

Bmathew Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Biju,

 

I'm posting here the proposed solution here as well.

If($c_currencyx=0,0,if($c_currencyx >=1 && $c_currencyx <100,2,if($c\_currencyx>=100 && $c_currencyx <500,2,if($c\_currencyx >=500 && $c_currencyx <1000,3,if($c\_currencyx >=1000 && $c_currencyx <2000,4,5)))))

Please let me know how you go.

 

Best regards,

Vanessa

Vanessa Michau 0 votes
Comment actions Permalink