Can you find the failure?

[dominik_m_]

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))

[arvind_patil · Accepted solution]

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

[pradosh_thakur · Accepted solution]

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))
)
)

[sunny_talwar]

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))