Thread: IF(OR - Help!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j5b9721 j5b9721 is offline
external usenet poster
 
Posts: 63
Default IF(OR - Help!

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...