Dear all,
i want use the IF Function for a range cells like below table but i think it doesn't work

{=IF(AND(A1:A8>100),"Not Ok","Ok") } -----> Ok
{=IF(COUNTIF(A1:A8,AND(A1:A8>100))>0,"Not Ok","Ok") } -----> Ok

table.JPG

Thank's