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?