i can't get this formula to work
 

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,"")

i can't get this formula to work
 

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,"")

i can't get this formula to work
 

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,"")

i can't get this formula to work
 

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,"")
.