=IF(OR(AC6:AG6<=-10%,AC8:AG8<-0.1),"Log","")

Try:
=IF(COUNTIF(AC6:AG6,"<=-10%")+COUNTIF(AC8:AG8,"<-0.1"),"Log","")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"j5b9721" wrote:
I have tried to make this work in a cell but I must be doing something wrong...
I tried different ways shown below... what am I doing wrong???

=IF(OR(AC6:AG6<=-10%,AC8:AG8<-0.1),"Log","")
=IF(OR((AC6:AG6)<=-10%,(AC8:AG8)<-0.1),"Log","")
=IF(OR((AC6:AG6<=-10%),(AC8:AG8<-0.1)),"Log","")
=IF(OR(AC6:AG6,AC8:AG8<-0.1),"Log","")
=IF(OR((AC6:AG6),(AC8:AG8)<-0.1),"Log","")

Thanks for helping...