i can't get this formula to work

[kyle]

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

 

[Roger Govier]

Hi Kyle

Try
=IF(AND((C2-C1)*24<-21,(C2-C1)*24>-23),1,"")

 

[Mike H]

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]

thanks, that did it

Hi Kyle

Try
=IF(AND((C2-C1)*24<-21,(C2-C1)*24>-23),1,"")

--
Regards
Roger Govier

.