i can't get this formula to work

  • Thread starter Thread starter kyle
  • Start date Start date
K

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