Prev: How do I recover the autosaved file?
Next: How to return to the previous active sheet after hyperlink?
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,"")
> .
>
 | 
Pages: 1
Prev: How do I recover the autosaved file?
Next: How to return to the previous active sheet after hyperlink?