Logic functions in DC's question

Guys how do simplify a function like this?:

=IF(PANEL!A=“E24”,“#8DC63F”,IF(PANEL!A=“E27”,“#8DC63F”,IF(PANEL!A=“E30”,“#8DC63F”,IF(PANEL!A=“E36”,“#8DC63F”,“#6E6E6E”))))

I’m struggling to use any functions other than IF(

Does anyone know of a resource to better explain Logic Functions?

=IF(PANEL!A=“E24”,“#8DC63F”,IF(or(PANEL!A=“E27”,PANEL!A=“E30”,“PANEL!A=“E36”),#6E6E6E”))

have you clicked on more>>
Capture

which will lead you to some examples

1 Like