Copying formula
 

Have formula =if(a1=1,"1",if(b1=1,"1")) in Column E1. How do i drag the
formula down to get the following results. In E2, i would like to get the
result =if(a1=2,"2"if(b1=2,"2")) and in E3 =if(a1=3,"3",if(b1=3,"3"))

--
thanx

Copying formula
 

Change the constants (1, 2, etc.) in your formulas to cell references (E1,
E2, etc.). Those references should include the corresponding numerical
values you want.

Dave
--
Brevity is the soul of wit.


"dmack" wrote:

Have formula =if(a1=1,"1",if(b1=1,"1")) in Column E1. How do i drag the
formula down to get the following results. In E2, i would like to get the
result =if(a1=2,"2"if(b1=2,"2")) and in E3 =if(a1=3,"3",if(b1=3,"3"))

--
thanx

Copying formula
 

=IF(A$1=ROW(),TEXT(ROW(),"#"),IF(B$1=ROW(),TEXT(RO W(),"#")))

I assume that you do want text, rather than numbers 1 and 2, as answers, and
that you want it to return FALSE if the conditions aren't met? [That's what
your formulae do.]
--
David Biddulph

"dmack" wrote in message
...
Have formula =if(a1=1,"1",if(b1=1,"1")) in Column E1. How do i drag the
formula down to get the following results. In E2, i would like to get the
result =if(a1=2,"2"if(b1=2,"2")) and in E3
=if(a1=3,"3",if(b1=3,"3"))

--
thanx