I have the following formula
"=if($a$1=$b$1-1,1,if($a$1=$b$1,2,if($a$1=$b$1+1,3,if($a$1<$b$1-1,if($a$1<$b$1,if($a$1<$b$1+1,SUM($b$1,b2))))))) .
I want to repeat that formula without having to use the tedious
edit/copy/formula method since I have thousands of comparisons. Can you
help? Thanks

See help on relative and absolute cell referencing using $ signs.


Gord Dibben MS Excel MVP

On Thu, 29 Jan 2009 16:08:01 -0800, Roysitito
wrote:

I have the following formula
"=if($a$1=$b$1-1,1,if($a$1=$b$1,2,if($a$1=$b$1+1,3,if($a$1<$b$1-1,if($a$1<$b$1,if($a$1<$b$1+1,SUM($b$1,b2))))))) .
I want to repeat that formula without having to use the tedious
edit/copy/formula method since I have thousands of comparisons. Can you
help? Thanks

Try highlighting the cells on the column
if you want the formula to appear in
the same column. If the formula should
appear in different places, select those
Cells by pressing ctrl and use your mouse
Without releasing the ctrl key,
Go to the first cell clicking on it, let say A2
Type the formula without the absolute reference,ie $
Press Ctrl and Enter together

This will put the same formula in those
cells you have select

Does this do what you want?
HTH
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis









"Roysitito" wrote:

I have the following formula
"=if($a$1=$b$1-1,1,if($a$1=$b$1,2,if($a$1=$b$1+1,3,if($a$1<$b$1-1,if($a$1<$b$1,if($a$1<$b$1+1,SUM($b$1,b2))))))) .
I want to repeat that formula without having to use the tedious
edit/copy/formula method since I have thousands of comparisons. Can you
help? Thanks