Nested if statement with average formula

[ryan2]

Please anyone can help me what is wrong wiht this statement?

if((Avg[F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*1.2),rgb(200,51,51),
if((Avg[F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(255,165,0),
if((Avg[F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])<(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(0,255,0),

)))

[MayilVahanan]

Hi @ryan2 

Try like below

if(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>
(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*1.2),rgb(200,51,51),
if(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])>
(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(255,165,0),
if(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Reel Çevrim])<
(Avg([F6 Ekran 6 (ar-arcelik_26011897).F6 Ekran 6 (ar-arcelik_26011897).Hedef Çevrim (%85 OEE)])*0.85),rgb(0,255,0)
)))

You've missed the ( for Avg() function as highlighted.

[ryan2]

thanks man.

you saved the day...