Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Copying a formula to multiple worksheets | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I prevent a formula element from incrementing when copying | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |