|
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... |
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... |
| All times are GMT +1. The time now is 05:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com