topic Can you find the failure? in App Development

Can you find the failure?

dominik_m_ — Thu, 31 Jan 2019 10:15:19 GMT

This doesn't work 😞
Can someone help me???

if(Kategorie=4101 or 4102,rgb(255,69,0),
if(Kategorie=4201 or 4202,rgb(255,165,0),
if(Kategorie=4301 or 4302,rgb(255,255,0),rgb(135,206,255))

Re: Can you find the failure?

arvind_patil — Thu, 31 Jan 2019 10:21:12 GMT

Hi,
Please Try Below:

if(Kategorie=4101 or Kategorie= 4102,rgb(255,69,0),
if(Kategorie=4201 or Kategorie= 4202,rgb(255,165,0),
if(Kategorie=4301 or Kategorie= 4302,rgb(255,255,0),rgb(135,206,255))))
Thanks & Regards,
Arvind Patil

Re: Can you find the failure?

pradosh_thakur — Thu, 31 Jan 2019 10:23:41 GMT

if(Kategorie=4101 or Kategorie=4102,rgb(255,69,0),
if(Kategorie=4201 or Kategorie=4202,rgb(255,165,0),
if(Kategorie=4301 or Kategorie=4302,rgb(255,255,0),rgb(135,206,255))
)
)

Re: Can you find the failure?

sunny_talwar — Thu, 31 Jan 2019 12:25:37 GMT

Might want to simplify it to this

If(Match(Kategorie, 4101, 4102), RGB(255,69,0),
If(Match(Kategorie, 4201, 4202), RGB(255,165,0),
If(Match(Kategorie, 4301, 4302), RGB(255,255,0), RGB(135,206,255))))

Or even this

Pick(Match(Kategorie, 4101, 4102, 4201, 4202, 4301, 4302) + 1, 
RGB(135,206,255), RGB(255,69,0), RGB(255,69,0), RGB(255,165,0), RGB(255,165,0), RGB(255,255,0), RGB(255,255,0))