Re: Advanced formula question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 17:24:14 +0100

Hi
if you start in row one with this formula try
IF(A1=INDIRECT(B5 & ROW()),1,0)
copy down 

--
Regards
Frank Kabel
Frankfurt, Germany
<anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:f8c501c40d04$60d5ef80$a401280a@phx.gbl...
> This works, thanks a lot!.
>
> But if I copy the formula down, I would have to incrament
> the "1" in each cell. Is there a way to have this behave
> as a normal formula, or do I have to build it it manually?
> >-----Original Message-----
> >Hi
> >try
> >=IF(A1=INDIRECT(B5 & "1"),1,0)
> >
> >--
> >Regards
> >Frank Kabel
> >Frankfurt, Germany
> >
> >"Pete Poxton" <anonymous@discussions.microsoft.com>
> schrieb im
> >Newsbeitrag news:af6101c40cfc$060f1480
> $a001280a@phx.gbl...
> >> I need to reference a cell within a formula as below. I
> >> could do it with Lotus, but Excel I can't.
> >>
> >> Assume cell B5 has "b" in it.
> >>
> >> Lotus;
> >> &"+if(a1="&b5&"1,1,0)"
> >> this formula would look at cell b5 for a column
> reference
> >> and then use it to calculate the formula as below;
> >> +if(a1=b1,1,0)
> >>
> >> Excel;
> >> ="=if(a1="&b5&"1,1,0)"
> >> When I try this all I get is the right thing but it
> shows
> >> me the text formula and not the calculated value.
> >> =if(a1=b1,1,0)
> >>
> >> Any Ideas?
> >
> >.
> >
Quantcast