Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(OR - Help!
=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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|