From: kyle on 17 Mar 2010 06:19 i'm trying to write a formula where if the cell below it minus the active cell is -21< x > -23 then write one, else leave it blank. so here's what i got so far, i think i'm just getting the parentheses wrong =if((AND((c2-c1)*24)<-21,((c2-c1)*24)>-23),1,"") i tried writing a simpler formula along the same lines and this one works =if((AND(j3<-21,j3>-23)),1,"") From: Roger Govier on 17 Mar 2010 06:29 Hi Kyle Try =IF(AND((C2-C1)*24<-21,(C2-C1)*24>-23),1,"") -- Regards Roger Govier kyle wrote:> i'm trying to write a formula where if the cell below it minus the active > cell is -21< x > -23 then write one, else leave it blank. > > so here's what i got so far, i think i'm just getting the parentheses wrong > > =if((AND((c2-c1)*24)<-21,((c2-c1)*24)>-23),1,"") > > i tried writing a simpler formula along the same lines and this one works > > =if((AND(j3<-21,j3>-23)),1,"") From: Mike H on 17 Mar 2010 06:54 Kyle, Try this =IF(AND((C2-C1)*24<-21,(C2-C1)*24>-23),1,"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "kyle" wrote: > i'm trying to write a formula where if the cell below it minus the active > cell is -21< x > -23 then write one, else leave it blank. > > so here's what i got so far, i think i'm just getting the parentheses wrong > > =if((AND((c2-c1)*24)<-21,((c2-c1)*24)>-23),1,"") > > i tried writing a simpler formula along the same lines and this one works > > =if((AND(j3<-21,j3>-23)),1,"") From: kyle on 17 Mar 2010 10:28 thanks, that did it "Roger Govier" wrote: > Hi Kyle > > Try > =IF(AND((C2-C1)*24<-21,(C2-C1)*24>-23),1,"") > > -- > Regards > Roger Govier > > kyle wrote: > > i'm trying to write a formula where if the cell below it minus the active > > cell is -21< x > -23 then write one, else leave it blank. > > > > so here's what i got so far, i think i'm just getting the parentheses wrong > > > > =if((AND((c2-c1)*24)<-21,((c2-c1)*24)>-23),1,"") > > > > i tried writing a simpler formula along the same lines and this one works > > > > =if((AND(j3<-21,j3>-23)),1,"") > . >